Use a cfsetting tag to change the page timeout. On Thu, Jun 19, 2008 at 9:46 AM, Gonzo Rock <[EMAIL PROTECTED]> wrote: > What's the best way to manage a process that takes a couple of hours to > complete? It's reading a records set from a database(2 seconds to load the > query) and then given the results it takes a couple of hours to write a > couple of hundred thousand text data files from the data. > > Problem is that the current technique dies after the Timeout request > setting, (from the CFadmin page), is reached for the cfm page that does this > work. Right now set at 300 seconds. > > It's built like this. > > cfquery the database > cfloop > cfinclude datawrite.cfm (this loop takes a few hours to complete > theoretically from watching 5 minutes worth of database writing before the > timeout.) > /cfloop > > How do some of you handle such a scenario? > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/CF-Talk/message.cfm/messageid:307692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
