By Rob, on September 3rd, 2010
One simple area of MySQL optimisation that is often overlooked is indexes* on tables.
Basically an index is a sub set of the data that allows the MySQL engine to match against values much faster than normal.
In short, it speeds up the sorting of data and therefore reduces the time it takes to return results and the load on the server as a result.
Continue reading MySQL Indices – what, how and when
By Rob, on September 2nd, 2010
We’ve got a really frustrating issue with our ColdFusion 8.01 box that seems to be getting worse as time goes on.
Every so often (the actually time seems pretty random – it could be 24 hours it could be 5 days) scheduled tasks that have been created in the ColdFusion Administration are simply disappearing.
There’s no pattern that we can see . . . → Read More: Scheduled Tasks – vanishing into the Void
By Rob, on September 1st, 2010
Almost on schedule and the immensely hard-working team behind Scotch on the Rocks have unveiled the speaker list for the 2011 conference in Edinburgh.
Amongst the usual luminaries of the CF community it’s good to see some UK community names in the list. The only problem? With that many speakers and 3 tracks I’m going to need to work double time on my self cloning technology to see . . . → Read More: SOTR 2011 Speakers – the wraps are off
By Rob, on August 9th, 2010
… without Java or authenticating against the CFIDE object!
I’ve recently been working on a pure ColdFusion / CFImage implementation to generate dynamic title images in specific fonts.
As part of the configuration of this particular code I needed to access the installed font list but the only method I could find documented required using CFIDE.adminapi.runtime which in . . . → Read More: How to access the font list in ColdFusion 8 …
By Rob, on August 4th, 2010
#bbpBox_20297427052{background:#9ae4e8 url(http://s.twimg.com/a/1279901730/images/themes/theme1/bg.png) no-repeat !important;padding:20px;}#bbpBox_20297427052 p.bbpTweet{background:#fff;padding:10px 12px 10px 12px !important;margin:0 !important;min-height:48px;color:#000000 !important;font-size:18px !important;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px}#bbpBox_20297427052 p.bbpTweet a {color:#0000ff !important}#bbpBox_20297427052 p.bbpTweet span.metadata{display:block;width:100%;clear:both;margin-top:8px !important;padding-top:12px !important;height:40px;border-top:1px solid #e6e6e6}#bbpBox_20297427052 p.bbpTweet span.metadata span.author{line-height:19px}#bbpBox_20297427052 p.bbpTweet span.metadata span.author img{float:left;margin:0 7px 0px 0px !important;width:38px;height:38px;padding:0 !important;border:none !important;}#bbpBox_20297427052 p.bbpTweet a:hover{text-decoration:underline}#bbpBox_20297427052 p.bbpTweet span.timestamp{font-size:12px;display:block}
Comments