Hi Stephen, 40 is an awfully high setting for Limit Simultaneous Requests, we typically recommend you set that to 3-7 * per CPU, with 7 being on the high side.
Regards, Christine Lawson Macromedia -----Original Message----- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:30 PM To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? How your's works is how I would have expected. At the moment , limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. ----------------------------- Stephen Richards 020 7903 3226 ------------------------------ ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 4:42 PM Subject: RE: Is Coldfusion REALLY multi threaded? > ..with regards to the long query...we have an app that has several queries that run quite long, a couple in the 3 or 4 minute range. These do not bring my CF server to a halt at all. We average almost 200 users per hour on busy days on this box. Have a look at all your CFAdmin settings. You may need to raise the 'limit simultaneous requests'. We have it set to 40 for a four proc machine. I have found through research and experience that if your app is very DB intense, raising this helps. Also look at lowering the 'restart at x unresponsive requests' We have it set at 5. Also make sure you have 'timeout requests after x seconds' checked and set reasonably. > > note that my experiences are with winblows boxen. on Linux boxen, this may very. > > Doug > > >-----Original Message----- > >From: Stephen Richards [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, December 05, 2002 11:23 AM > >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm