Can we see you exact query code? There are a few things you can do to optimize, firstly don't use *, list the columns with a comma to separate them, it'll speed the query up. Next on your output scope your column to the query like #get_info.Code# and #get_info.descr#.
That'll help for a start I'm sure. Rob -----Original Message----- From: ismail cassiem [mailto:[EMAIL PROTECTED] Sent: 17 May 2007 12:09 To: CF-Talk Subject: Optimize Query Write Output Time Hi, I have a query: select * from table - runs for 3 seconds in Quer Analyser Output Analyse Grid - Fine Now for my Coldfusion report i execute the same query without outputing to screen, <table> <cfoutput query="get_info"> <tr> <td>test(not a field)</td> </tr> </cfoutput> </table> Then the report runs 4 seconds: fine But the moment i add the output: It runs for a minute. <table> <cfoutput query="get_info"> <tr> <td>#Code#</td> <td>#Descr#</td> <td>#Descr8#</td> <td>#Descr9#</td> <td>#Descr10#</td> </tr> </cfoutput> </table> Please anyone help, really appreciate it! Regards, Ismail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
