Run SQL Profiler from a remote computer and see if the queries are taking long to execute on the database server. You want to isolate the problem if possible, and knock out the ColdFusion server or the network connection from the list of possible culprits. It isn't clear from your message where the slowness is occurring.
-Mike Chabot On Jan 22, 2008 1:27 PM, Kevin Roche <[EMAIL PROTECTED]> wrote: > 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:297079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
