Since I asked this question I have seen Slowest Requests that have lasted over the weekend (233,333 seconds)?!?
The connection pool never got over 10 on any one server. I have Aborted dozens of requests but there seem to be many of these very slow ones left. They all use the same datasource and no other datasources have had a problem. The only change I can think of is in all cfqueries where I had: select myColumn from myProblemSchema.myTable and I changed it to: cfquery name="myQuery" datasource="myProblemSchema"> select myColumn from myTable </cfquery (I was told this would speed everything up and just naively believed it) My database guy gives me a sheepish look when I ask him for the true Maximum Pool Connections number. > Date: Wed, 4 Mar 2009 08:27:48 -0500 > Subject: [CFCDEV] Re: max pooled statements > From: [email protected] > To: [email protected] > > > You could create a new entry to check this. My default is 1000 in CF8 > Developer Edition for a SQL Server 2005 data source. > > -Mike Chabot > > On Tue, Mar 3, 2009 at 10:55 PM, Mark Ireland <[email protected]> wrote: > > In a datasource does Max Pooled Statements normally default to 300? > > > > > _________________________________________________________________ Looking for a place to manage all your online stuff? Explore the new Windows Live . http://www.microsoft.com/australia/windows/windowslive/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
