February 14, 2003 at 7:46 am
Has anyone experienced a problem from executing a stored procedure from within itself? It works, otherwise the code wouldn't be there, but I have concerns about performance. Any Opinions?
Derek
Derek
February 14, 2003 at 7:49 am
Dont think I have any at the moment. Recursive solutions not that common. Concerns that there might be a problem, or you really are having a problem?
Andy
February 14, 2003 at 9:55 am
I've done it as a test to how well SQL Server handled "true" recursion and we even have a few stored procedures being used in a production environment that use it. However, it is experiencing a SP:Cache Miss event every time it recurses. This may be due to the fact that the developer used a global temp table and didn't flag it not to cause a recompile.
Can't really tell you the performance implications because the application in question is too small to really measure (the stored procedures, including recursing execute in < 5 ms).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 20, 2003 at 5:49 am
Thanks for the responses. I don't know for sure if it is the only problem.
Derek
Derek
February 22, 2003 at 3:16 pm
When you run a profiler trace and look for things like lock timeouts, lock deadlocks, and recompiles, what are you seeing?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply