|
Posted by Jerry Stuckle on 09/08/06 21:46
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
>
I think an mssql newsgroup might be a better place to ask this. I
suspect it's going to be in some parameters in mssql.
There shouldn't be any difference from the PHP end.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|