It when the last record returns. Snippet from log: "Warning","jrpp-1453","07/03/07","12:32:34",,"Thread: jrpp-1453, processing template: D:\iserver\...\main_oracle.cfm, completed in 47 seconds, exceeding the 30 second warning limit"
I'm not sure what the isolation level (don't have read access) is on the procedure, but can't see how it would, or could, be different between the two execution methods. > Steve Brownlee wrote: >> I'm hoping some system engineers or DB admins can answer this better >> than >> I can. Got a problem with one of our CF servers hitting a stored >> procedure. >> >> 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. > > Is that until the first record is returned or until the last record is > returned? Is the transaction isolation level the same for both? > > Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4