Multiple SPs OR one SP w/ Multiple Recordsets (Part 2)

Multiple SPs OR one SP w/ Multiple Recordsets (Part 2)

Post by Sam » Thu, 11 Apr 2002 22:16:37



Hi,

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
demanding environment.

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
elaboration. Thanks.

Sam

 
 
 

1. Multiple SPs OR one SP w/ Multiple Recordsets (Part 2)

Hi,

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
demanding environment.

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
elaboration. Thanks.

Sam

2. Update Question

3. Multiple SPs or single SP with multiple selects?

4. A Question on I Descriptor's

5. Newbie Q: Multiple Recordsets Returned as One in SP

6. converse db with different codepage

7. Problem Getting Recordset From Multiple Select Statement SPs

8. compactdatabase w/ pwd...

9. Load combo boxes: one recordset or multiple recordsets?

10. column in multiple rows to multiple columns in one row

11. multiple connections vs multiple statements on one connection

12. web one entry for multiple field search??multiple

13. column in multiple rows to multiple columns in one row