http://blog.classsoftware.com/index.cfm Web technologies and applications focusing on ColdFusion, Flex and Flash. http://www.classsoftware.com/images/logosm.gif http://blog.classsoftware.com/index.cfm en-us Thu, 09 Sep 2010 05:24:06 +1000 Sat, 12 May 2007 09:00:00 +1000 BlogCFC http://blogs.law.harvard.edu/tech/rss justin@classsoftware.com (Justin Mclean) justin@classsoftware.com (Justin Mclean) http://blog.classsoftware.com/index.cfm/2007/5/12/ColdFusion-Database-Indexes The most common problem I've run into with applications slow performance is the lack of indexes on the databases. Sometimes this is just because the application ran fine with a small amount of data but now is working off a larger amount, or the application is being used in unexpected ways (running less 'common' queries run more often), or the production environment doesn't have the same indexes as the development environment or worse case the indexes were never created in the first place. Without indexes queries can take seconds with indexes they take milliseconds! [More] ColdFusion Database Performance Sat, 12 May 2007 09:00:00 +1000 http://blog.classsoftware.com/index.cfm/2007/5/12/ColdFusion-Database-Indexes