s. isaac dealey wrote: > If CF is handling the database access you can set a timeout on the query > to prevent it from tying up the server?
CF is not handling the query. It is simply the interface to build the query which then is submitted to the database. Stored procedures then run the queries in the que, write the results to files on a FTP server and send an e-mail back to the requester when this is completed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4