Ask a Question related to ASP Database, Design and Development.
-
Targa #1
Best way for implementing mutliple select statements
What's the most efficient method for using multiple select statements from
different tables?
Open db connection once or open connection for each query?
Targa Guest
-
#40639 [NEW]: DBLIB driver segfaults on repeated prepared select statements
From: spheroid@php.net Operating system: Mac OS X 10.4.8 PHP version: 5CVS-2007-02-26 (CVS) PHP Bug Type: PDO related Bug... -
Combing two simple select statements. There must be a way?
Hi I have two select statements that work correctly. They are as follows: SELECT DISTINCT user.* FROM user_tab AS user INNER JOIN... -
Use MS Access to write SQL select statements
Hello, I am not sure if this is common knowledge or not, but I just figured out how to use MS Access to write my sql select statements for me. ... -
recordset.recordcount return allways -1 on select statements
Greetings On my ASP application I want to retrieve the number (Recordset.recordCount property) of records affected by a select statement, but I... -
Using IF and IsNull statements in SELECT
You would do something like this... select CustomerLastName + isnull(', '+CustomerFirstName,'') from tb -- -oj RAC v2.2 & QALite!... -
Bob Barrows [MVP] #2 Re: Best way for implementing mutliple select statements
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
the response.
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.
Bob Barrows
--
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
"NO SPAM"
Bob Barrows [MVP] Guest
-
Aaron Bertrand - MVP #3 Re: Best way for implementing mutliple select statements
Open one connection per page.
--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]
"Targa" <targa1SPAMSUCKS@alltel.net> wrote in message
news:#mqewgYOEHA.1616@TK2MSFTNGP12.phx.gbl...> What's the most efficient method for using multiple select statements from
> different tables?
>
> Open db connection once or open connection for each query?
>
>
>
Aaron Bertrand - MVP Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
