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.