Optimizing ColdFusion Queries by Reordering SQL Clauses

Apr 12, 2002

Complex or multiple ColdFusion queries can create slow performance on a page. In such cases, you may be able to improve performance by reordering SQL clauses in the cfquery statement. This article gives you some interesting tips on how to speed things up.

Latest ColdFusion Talk (CF-Talk)

Output newest one item from each category
cftextarea setValue() and jquery dialog
query add row at top of query
ColdFusion 9 ajax controls
Need a west coast (US) based ColdFusion host
SOT: SQL Server Data Archival - my solution
sensitive data collection practices with ColdFusion
SQL Server Data Archival - my solution
Bind to a CFINPUT from a CFGRID
Need a west coast (US) based ColdFusion host [spamtrap heur]

Latest ColdFusion Jobs (CF-Jobs)

Code Junky Wanted in Downtown Chicago!
Coldfusion Developer in Los Angeles
Full time ColdFusion position in Arlington, VA (Rosslyn)
Coldfusion Opportunities: Washington DC and Alexandria, VA
ColdFusion Developers who can obtain a DoD Secret in the DC Metro Area
ColdFusion Programmer Opportunity in Nashville, TN
ColdFusion 8 Development Position in Arlington, VA
Web Application / ColdFusion Developer (Permanent/Houston)
Small Work for Site Migration from CF8 Win 03 to CF9 Win 08
Southern California Development Company Seeks Reliable Mid Level Developers

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?