Barneyb, I appreciate you taking the time and effort to help clarify.
Thanks, Nick At 12:24 AM 1/14/2005, you wrote: >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:190393 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
