Hi. I run a bunch of queries all over without setting the TIMEOUT attribute of CFQUERY. Does this make you gurus cringe? Are you gritting your teeth, hearing my application crashing to screeching halt all over the place? I read that CFQUERY calls, if they wait for a third-party (the back end database) that doesn't respond, won't return an error. In such a case, CFAS is doing what it's supposed to, and it passes the buck on to the third party. The thread stays locked up indefinitely. Then let's say that piles of requests come in. The works get clogged and the server hangs. Am I making this up? Is it reasonable to expect that such a sequence of events might occur? If I should use the TIMEOUT attribute, is it one of those "can't do any harm" deals, as long as I don't set it so absurdly short that no query can finish in time? Thanks, Matthieu
Pfizer Information Center ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
