There are some pretty knowledgable people here and I'd like to thank them
for sharing their wisdom and experience with us.
This was a question I brought up a while ago and Aaron and some other guys
were nice enough to answer my question. I'd like to go a little deeper this
time if I may.
What I learned from my previous question was that one big stored procedure
with multiple recordsets was more efficient than many smaller stored
procedures. I now have a stored procedure that produces 7 recordsets.
Performance-wise I'm pretty happy with though it's not really used in a very
My question is: why is it that one SP is more efficient than many SPs? What
really eats up more system resources in terms of CPU cycles or memory or
both? Is it the connection to the DB? I'd really appreciate your