How many records are coming back? How are you calling it?
I have ran tests before for where running exec sp_name in side of a cfquery was faster than cfstoredproc. Just a thought. Also are you sure the stored proc is really taking 20 seconds to run OR is the CF page just taking 17 seconds to produce its output. This could be determined by running a trace while you hit the page if you are using SQL Server. ~Brad -----Original Message----- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 12:45 PM To: CF-Talk Subject: OT: sql question I have a stored procedure that is taking 15-20 seconds to run. However, if I take the query inside the stored procedure and run it... it only takes 2-3 seconds. I've read something about parameter sniffing but not sure if it applies to my stored procedure. Here is my sp: CREATE PROC dbo.get_vendorActivityPeriod ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4