You can set a timeout on a query, so that the DB client (CF, in this case) will stop waiting for a response from the DB server. That's what you're setting with CFQUERY. CF also puts an overall timeout on page execution so that if you have a long running process (or an infinite loop) it won't take down the server, because CF will kill it off whether it's done or not. I suspect you're running into the latter, since the default is 60 seconds, and might have been set even lower by your shared host.
You set the former with the CFQUERY tag, you set the latter either in the CF admin or with the requestTimeout attribute of the CFSETTING tag (which is specific to the request that the CFSETING tag runs as part of). By and large, batch processing tags usually need a CFSETTING tag to extend the request timeout, because if you want to protect your server with the default (from the CF admin), it'll be too short to let your batch complete. On a shared host you have to be respectful of other clients, but on my dedicated servers, I usually just set any batch process to have a 5 minute timeout, and then adjust up if needed. Just for reference, I use a 45 second default. cheers, barneyb On Thu, 13 Jan 2005 23:57:58 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > Barneyb, > > I don't understand what is the difference in a request timeout and a query > timeout? > > What variable do you set? > > Thanks, > > Nick -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 9 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
