slow database connections

Results 1 to 2 of 2

Thread: slow database connections

  1. #1
    Join Date
    Dec 1969

    Default slow database connections

    Hi there, I&#039m having trouble with my IIS running on a win2k pro system. The database connections are really slow. When a ASP script with database connections is being executed, the harddisk makes a lot of noice, and the page returns after waiting a long time..<BR>The scripts are using DSN connections via ODBC. All the connections and recordset&#039s are closed. Re-install of win2k gives no change to this situation.<BR>Anyone knows how I can solve this problem?

  2. #2
    Join Date
    Dec 1969

    Default RE: slow database connections

    Could be a number of things. What database are you using and is it on your local machine? How&#039s your virtual memory configured?<BR><BR>If you&#039ve got your DB running locally, but a low initial VM setting, then I would expect Windows to have to enlarge it&#039s pagefile before it has enough memory to start processing, which is fairly disk-intensive. Just speculation really, but try setting your *minimum* VM size to at least 512MB.<BR><BR>Dunc

Posting Permissions

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