Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2001-12-07 : 14:16:09
|
| Hi I have a vb app that is calling a SQL stored procedure via ADO. This initialization store procedure returns 5 distinct rs that I use to populate all of my variables. (This way I only hit the db once.) I was just curious if any one has ever run into problems returning a larger number of rs from one SQL call? I have noticed that ADO gets overwhelmed sometimes when you return mulitple rs along with multiple Return and Output variables. Thanks NicNic |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2001-12-16 : 07:07:18
|
quote:
Hi I have a vb app that is calling a SQL stored procedure via ADO. This initialization store procedure returns 5 distinct rs that I use to populate all of my variables. (This way I only hit the db once.) I was just curious if any one has ever run into problems returning a larger number of rs from one SQL call? I have noticed that ADO gets overwhelmed sometimes when you return mulitple rs along with multiple Return and Output variables. Thanks NicNic
HIHow many recordsets would u like to return.i have used maximum of 12. No Such situation i faced. |
 |
|
|
|
|
|
ADO and NextRecordset