|
||||||
|
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 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 The following is a log of a recurring issue with our ColdFusion 8 Standard server. The JRun server is currently crashing every other day with the active thread error (error 1). If the ColdFusion service is not restarted the system will then proceed to run out of memory (error 2) despite Windows still having 0.5 – 1GB to spare Continue reading ColdFusion 8.0.1 – server stability and memory usage issue For the past 2.5 years I’ve maintained a dedicated server for hosting various sites, both of my own and for clients. I’d been running the same box for a while when, in January, I finally decided I needed to upgrade to a bigger, better machine with an OS I could actually patch (the old server was a Fedora Core 5 machine and Yum was borked beyond repair). Continue reading Not one, not two but 6 Servers per Server |
||||||
|
Copyright © 2010 blog.rubicon.je - All Rights Reserved 35 queries. 0.408 seconds. |
||||||
Comments