Funky Stored Procedure execution pattern.

Last Post 17 May 2002 11:13 AM by rfmerchant. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
rfmerchant
New Member
New Member

--
17 May 2002 11:13 AM
Hi All:

This would sound rather strange to you guys but here it is.
I have this sql that I execute in query analyzer and it takes about 4 sec to return 55 records. Now when I wrap this sql in a stored procedure it takes close to about 5 min to execute. I dont understand this and has been driving most of us crazy.
Did someone in this discussion board encounter a similiar problem and what they did to resolve the problem.

Thanks for any help.
You are not authorized to post a reply.

Acceptable Use Policy