Ben, Search House of fusion for a recent thread on query optimization as well... There was an interesting issue with a stored proc taking too long and it turned out to be permissions on the database (made me go hmmmmm.....)
-mark -----Original Message----- From: Ben Mueller [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 2:17 PM To: CF-Talk Subject: SQL Server connection best practice? Hi all, I'm not even sure how to pose this question, so I did a poor job of searching the archives, if this question has already been answered. We're running CFMX7 and SQL Server 2000 in Windows2003 Server. I know there are a variety of ways that one can get CF to talk to a SQL Server box: ODBC, JDBC, Named Pipes, and so on. I don't even pretend to know what all of that really means. The question is what's the best practice these days? I think at one point, ODBC was faster, but then JDBC was recommended, and now I'm no longer sure. This came up because I ran a query in SQL Server query analyzer that returned the result set in 0 milliseconds. however, running it using CFQUERY (debugging enabled) showed that the query took about 800ms to execute. The recordset returned is pretty big, so I'm assuming that the bulk of the 800ms is the transfer time, and that got me to thinking about the above question. Any guidance is appreciated. Thanks, Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:295727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
