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 |
|
the1gadget
Yak Posting Veteran
55 Posts |
 Posted - 2005-09-08 : 09:06:09
|
| Hi AllJust taking over a classic ASP site with lots of stored procedures. The problem is (I think) that they do a lot of text manipulation and then execute a single Single SQL statement for each record that is required, and return it as a different record set.What I am really asking is is this good practice to.1) Create a new query in a stored procedure2) Return multiple record sets.-- David |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-08 : 10:43:09
|
| reducing round trips to the server is a good thing. make sure they are not opening and closing multiple connections as well. try to wrap all of their little stored proc's into an uber proc. test results before and after with a static set of data.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
|
|
|
Stored Procedures