Hi Everyone, I am running ColdFusion 8 with SQL Server 2005. I recently decided to take a direct query against the database and simply move it into a stored procedure instead. So before I was doing a <cfquery> I am now doing a <cfstoredproc> instead. After I made the change, I logged onto my website and requested the data from the interface and it took a long time for database to retrieve the result. I began digging into this by looking at the performance of my database server while the request was running. I discovered that it was reading from the disk for the entire time. I know your first reaction will be to tell me to check my table, index, queries etc...but here is the kicker. After I executed the stored procedure from the front end, I logged onto the database server, opened SQL Studio Management Express, executed the same stored procedure with identical parameters and it returned within a couple of seconds (ALL WHILE the front end was still waiting on the same data!). Does anyone have any experience with a similar problem. Basically, I'm seeing different database behavior from Coldfusion vs. directly against the database (SQL Studio Management Express).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
