Does having more than one Recordset slow down a page in any way?

[MustangManny]

I have a page that has 5 recordsets, each with a particular SQL query to filter out five different tables of info one page.
Would having more than one recordset slow things down? If so, is there an easier and/or efficient way around it?

Thanks In Advance.

 

[Extentec]

Yes have this many queries will slow things down a bit. Not because of the database (they are pretty fast no matter how you slice it) but because of the resources required to manage five connections to the database. The most efficent way to accomplish this (at least I think, any comments appreciated) would be to create a database view (SQLServer), Stored Procedure (Oracle, SQLServer), or a predefined Query (MS Access) that makes all the necessary table joins and returns exactly the recordset you are looking for.

This allows you to make one query and retun exacly what you need minimizing the server overhead in managing the objects and connection. Hope this helps.

http://www.onti.net

 

[MustangManny]

Thank you!