Be sure that connection pooling is checked on the datasource in Coldfusion -----Original Message----- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 22, 2008 1:28 PM To: CF-Talk Subject: ColdFusion slow database connection to SQL2005
The envionment is CF7.0.2 and SQL Server 2005. It appears that queries are taking longer than usual to complete. Even simple queries can take over a second to execute. The test server has no problem executing the same query in 100ms. I supect there is some configuration issue which means that the database connections are dropped after each query, but I am not sure what is going on. The fact that it all works perfectly in test and the same code ran without any problem on CF5 and CF6.1 makes me sure there is somthing off with the configuration but I can't find it and the DBA isn't able to see any problem on the SQL Server either. We are using SQL Authentication rather than NT Authentication. Anyone out there seen somthing like this? Kevin Roche ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
