> I'd try to override the timeout with cfsetting and I also thought about > change the setting in cf admin but I am not sure of what is a safe setting.
Experiment. Set it to five minutes for the report and see what happens. You should have a reasonably low value for cfadmin (30-60 seconds), and use cfsetting for specific long requests. > Can anyone tell me the best way to run large reports? Whether you choose to use CFML, or some part of MS SQL Server, make sure you have correct indexes on all the tables involved. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3136 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
