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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2003-03-15 : 07:53:08
|
| Hi,I needed to execute two select statements from ASP, would be better to use two stored procedures or one stored procedures for both and later use the two recordset at ASP Page.Thanx. |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-03-15 : 08:09:08
|
| Well depends upon a *lot* of factors, but I would think that a single SP that returns two recordsets might be faster (but then, RS.NextRecordset is not terribly fast either). In the end, you should conduct a small test with a reasonable amount of data to determine it for yourself.OS |
 |
|
|
|
|
|
asp-sqlserver optimise