note 35551 deleted from ref.mssql by sniper
| From: | sniper@php.net | Date: | Mon, 17 Nov 2003 22:58:38 +0000 |
| Subject: | note 35551 deleted from ref.mssql by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-60537@lists.php.net to get a copy of this message | ||
Note Submitter: ashearer@shearersoftware.com
----
Beware enabling this extension without installing a new copy of ntwdblib.dll, even if it seems to
work. Drag-installing SQL Server 2000's copy of ntwdblib.dll (with a date in the year 2000,
replacing an existing 1998 version) solved a performance problem.
I had noticed a slight slowdown of simple PHP pages, and it turned out that just having the
php_mssql extension enabled in php.ini was adding 0.5 seconds to each page load. Even "Hello
world!" always stuttered for half a second. (Reproduced on two different Windows 2000 servers
with IIS 5, under both CGI and FastCGI, PHP 4.3.2 and 4.3.3.) Updating ntwdblib.dll fixed both
servers.