improving performance

Discussion in 'ASP General' started by Joey Martin, Apr 30, 2004.

  1. Joey Martin

    Joey Martin Guest

    If I call the database 5 times on a page using multiple queries, recordsets,
    etc what all do I need to do to "close it all out"?

    I close the database connection at the end of each page. Should I clear out
    the recordsets or anything else? I just want to make sure I am performing
    good practices.

    Thanks.
    Joey Martin, Apr 30, 2004
    #1
    1. Advertising

  2. "Joey Martin" <> wrote in message
    news:dbxkc.45385$...
    > If I call the database 5 times on a page using multiple queries,

    recordsets,
    > etc what all do I need to do to "close it all out"?
    >
    > I close the database connection at the end of each page. Should I clear

    out
    > the recordsets or anything else? I just want to make sure I am performing
    > good practices.
    >
    > Thanks.
    >

    Close each recordset, close each connection, set all recordset and
    connection objects to Nothing

    --
    John Blessing

    http://www.LbeHelpdesk.com - Help Desk software priced to suit all
    businesses
    http://www.room-booking-software.com - Schedule rooms & equipment bookings
    for your meeting/class over the web.
    http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
    John Blessing, May 1, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Robin

    Improving Performance in ASP.Net

    Robin, Mar 4, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    402
    Scott Allen
    Mar 4, 2005
  2. ruds
    Replies:
    13
    Views:
    572
    squirrel
    Apr 8, 2007
  3. Dale
    Replies:
    2
    Views:
    763
    Mike Meyer
    Jan 11, 2008
  4. yawnmoth
    Replies:
    6
    Views:
    1,528
    yawnmoth
    Aug 5, 2008
  5. Ryan Rosario
    Replies:
    1
    Views:
    238
    odeits
    Mar 19, 2009
Loading...

Share This Page