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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
