note 53620 deleted from function.mssql-connect by cmb
| From: | cmb@php.net | Date: | Sun, 11 Aug 2019 13:17:27 +0000 |
| Subject: | note 53620 deleted from function.mssql-connect by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211874@lists.php.net to get a copy of this message | ||
Note Submitter: pelanne at gmail dot com
----
Just in case it helps people here... We were being run ragged by extremely slow connections from
IIS6 --> SQL Server 2000. Switching from CGI to ISAPI fixed it somewhat, but the initial
connection still took along the lines of 10 seconds, and eventually the connections wouldn't
work any more.
The solution was to add the database server IP address to the HOST file on the server, pointing it
to the internal machine name. Looks like some kind of DNS lookup was the culprit.
Now connections and queries are flying, and the world is once again right.