It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free.
Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the CF app to a new server solved the problem. Jason Lees Systems Developer National Express Coaches Ltd. -----Original Message----- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 16:23 To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? > Stephen Richards wrote: > > > > We have 24 connections at the moment, as reported by the database. (can't > > use netstat because the CF server is running on the same machine as the > > database, so it's a unix socket rather than port 5423. > > And how many of them are idle? In the mean time you might want to get > somebody to look at that query, since 2 minutes is rather long. > how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. ----------------------------- Stephen Richards 020 7903 3226 ------------------------------ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
