Database connection performance

Results 1 to 2 of 2

Thread: Database connection performance

  1. #1
    Join Date
    Dec 1969

    Default Database connection performance

    I am setting up a pretty small scale website which will utilize an access database for most pages. It&#039s not going to be a very big site, but I am concerned about performance. <BR>What is the best way to maintain good performance on a website accessing a database continually?<BR>Should I close each connection? Should I set each connection to nothing to clear out memory? Does anything else need to be done with the connections?<BR><BR>Thanks a lot,<BR>John

  2. #2
    Linda N. Guest

    Default RE: Database connection performance

    Recommend closing the recordset and the connection at the end of each page. I also would suggest using a dsn-less connection just out of personal experience with my ODBCs dropping out of IIS and the service not starting. There is a tutorial on this site as well as asp101 if you are unsure how to do that.<BR><BR>--Linda

Posting Permissions

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