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:307689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
