Database connections

Results 1 to 3 of 3

Thread: Database connections

  1. #1
    Join Date
    Dec 1969

    Default Database connections

    Question, If you have a database with 6 tables that you have to query on one page. Is it best to open and close the database connection with the recordset, or to keep the database connection open then just open and close the recordset with each query?

  2. #2
    Join Date
    Dec 1969

    Default RE: Database connections

    I would open the db connection once close it after you close the last rs

  3. #3
    Join Date
    Dec 1969

    Default Keep the connection open.

    Close it as soon as you no longer need it on the page (after the last recordset it closed).

Posting Permissions

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