| php-taz 2006-09-08, 6:58 pm |
| I built a PHP website on Windows 2000 (using IIS) that connects to a
SQL Server 2000 database using the mssql functions. I migrated the
website and the database onto a Windows 2003 machine, and now the mssql
functions are significantly slower. On the Windows 2000 machine, the
mssql_connect takes .03 seconds to run, and the odbc_connect takes the
same amount of time. On Windows 2003, the mssql_connect takes a full
second to run, but odbc_connect only takes .017 seconds. I have tried
both ISAPI and CGI for the php configuration in IIS, and I have
experimented with different values for the output_buffering parameter
in php.ini, but neither of these seem to make a difference. Why would
the mssql commands be so much slower on IIS 6? I would rather not have
to change all the database calls to be odbc instead of mssql
|