Posted by Chung Leong on 09/08/06 21:17

php-taz wrote:
> 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

How do you authenticate? SQL user/password or secured connection?

[Back to original message]