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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

