Run SQL Server Profiler from a remote machine to watch the queries and response times. You said running the query directly is fast, which is a good first step, but execuiting the query via ColdFusion is slightly different and it would be good to make sure the query times as observed through the Profiler tool are the same as what you are seeing directly. There are many possible reasons for the slowness, but this is where I would start.
Good luck, Mike Chabot On Dec 12, 2007 5:04 AM, Kevin Roche <[EMAIL PROTECTED]> wrote: > I just upgraded one of my customers from CF5 to CF7. > > The site works but the queries are very slow. I have a test machine here in > the office and the queries take 30ms or so there but on the staging machine > and production machine the responce to the same query is 600ms. > > The only difference is that the test machine is using Win 2000 and the > staging and production machines are using Win 2003. All are using MS > SQLServer 2005. I have tried running the query concerned on the production > Database with SQL Management Studio and that happens very quickly. > > There is another symptom. That is that some queries fail with a message > saying that there are too many connections to the SQL Server. It is as if the > number of connections is being limited by somthing. We are not using the > Express version of SQL Server so I am at a loss. > > Its almost as if ColdFusion connection pooling is not working and its > creating anew connection every time rather than reusing an exsiting datbase > connection. > > I am considering upgrading the DataDirect JDBC Drivers but that is just a > stab in the dark. Anyone else know any reason why this would happen? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
