Targa wrote:I use a single connection object in each page. I keep the connection open> What's the most efficient method for using multiple select statements
> from different tables?
> Open db connection once or open connection for each query?
during the lifetime of the page, closing and destroying it before sending
While OLEDB Session Pooling or ODBC Connection Pooling will minimize the
impact of opening your connection, the fact remains that there IS an impact.
It makes no sense to open a connection, run a query, close the connection,
open the connection, etc in a single page.
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the