moving the CF server onto another box was indeed the next line of attack, until I saw that if the query was executed from outstide CF, then other users, invluding CF users couls access the DB fine.
It's definitely not table locks unless the DB puts the lock on when the query comes from CF, and not when it comes from a client. SR ----------------------------- Stephen Richards 020 7903 3226 ------------------------------ ----- Original Message ----- From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 4:50 PM Subject: RE: Is Coldfusion REALLY multi threaded? > 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
