|
||||||
|
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 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. Continue reading Scheduled Tasks – vanishing into the Void … 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 turn requires that the code has the CFIDE admin username and password embedded. Continue reading How to access the font list in ColdFusion 8 … @sagarganatra @robdudley if only a single feature was added to ColdFusion Builder 2, it should be Linux support A topical issue at the moment – Adobe’s lack of support for ColdFusion builder on a platform that isn’t proprietary(Windows, OSX) is something that is very close to my heart. Continue reading Why Adobe should support ColdFusion Builder on Linux Scotch on the Rocks is done and done! I’m back home and relaxing the glow of 2 (and a bit) days spent learning stupid amounts of cool stuff, meeting even cooler people and doing it all in one of the coolest conferences I’ve ever had the good fortune to attend. Continue reading Scotch on the Rocks 2010 – The slightly emotional preamble. For those of us running on ColdFusion 8, Ben Nadel’s wrapper to the Apache POI classes are still the best way of working with native Excel files. That said, the POI that ships with CF 8 is old … very old … 2004 old in fact and as such it has to be treated very gently and chokes on the slightest bit of Excel cleverness. The most common example of this that I’ve come across occurs when trying to import a sheet that has Auto Filter / Sort enabled. The Java layer explodes in a mess of unhandled exceptions and steadfastly refuses to read the file. Continue reading Upgrade Java POI for Better Excel Support in ColdFusion 8 |
||||||
|
Copyright © 2010 blog.rubicon.je - All Rights Reserved 35 queries. 0.463 seconds. |
||||||
Comments