Same results. 8-9 seconds from local or dev boxes. 30+ seconds on production box. I think I may just have to chalk this one up to "heavy user load". There's just too many users creating too many DB connections and this call (already slow at 9 seconds under no load in my opinion) just takes the brunt of the damage.
>> If I execute this procedure manually from the SQL Server >> Console from my machine or one of the common dev machines, >> the execution time is 9 seconds. However, today we've been >> seeing warnings in the logs, on the CFSTOREDPROC tag in the >> code. Time of execution is being reported in the range from >> 32 seconds to 90 seconds. > > Just for kicks, can you try changing the CFSTOREDPROC to a query that > calls > the stored procedure? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
