Professional Web Applications Themes

Best way for implementing mutliple select statements - ASP Database

What's the most efficient method for using multiple select statements from different tables? Open db connection once or open connection for each query?...

  1. #1

    Default 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

  2. #2

    Default Re: Best way for implementing mutliple select statements

    Targa wrote:
    > What's the most efficient method for using multiple select statements
    > from different tables?
    >
    > Open db connection once or open connection for each query?
    I use a single connection object in each page. I keep the connection open
    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

  3. #3

    Default 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" <targa1SPAMSalltel.net> wrote in message
    news:#mqewgYOEHA.1616TK2MSFTNGP12.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

Similar Threads

  1. Replies: 4
    Last Post: February 27th, 01:22 PM
  2. Combing two simple select statements. There must be a way?
    By ukr_bend@yahoo.com in forum MySQL
    Replies: 5
    Last Post: March 24th, 06:10 PM
  3. Use MS Access to write SQL select statements
    By StylusDesigns in forum Macromedia ColdFusion
    Replies: 2
    Last Post: June 1st, 11:37 PM
  4. recordset.recordcount return allways -1 on select statements
    By Sérgio Almeida in forum ASP Database
    Replies: 2
    Last Post: October 24th, 11:17 PM
  5. Using IF and IsNull statements in SELECT
    By oj in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 2nd, 03:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139