Posted by php-taz on 09/08/06 21:55

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

• Next in forum: [PEAR] How to get the value of an auto_increment primary key after an insert ?
• Prev in forum: Re: Ultimate programmer's reference - Quickref.org launches
• Thread view: MSSQL slow on IIS 6

[Reply to this message]