ID: 28610 Comment by: extranet at skoda-auto dot de Reported By: michael dot lidgren at cypoint dot se Status: Open Bug Type: Performance problem Operating System: Windows Server 2003 PHP Version: 4.3.6 New Comment:
Same Problem here, php ist extremely slow under Windows 2003 Server running in ISAPI Mode. CGI Speed it up but it doesnt reach Speed like running under Windows 2000. Any Help possible? Output Buffering = On helps a lot but it is still slower than in windows 2000. Previous Comments: ------------------------------------------------------------------------ [2004-11-09 11:49:11] i_know_u21 at yahoo dot com I consider PHP as the best web tool I have experienced, but I have been experiencing the same problem, I have a big PHP application, running on Windows XP/2000/2003, I used to use CGI under IIS but i constantly got the error "CGI scripts doesn't behave"! i tried all that was written in all web sites i searched within but still CGI never behaved! so i had to switch to ISAPI. I noticed how slower ISAPI is compared to CGI, but this never was a problem when few records were retrieved from MS SQL (from 20 to 100) now my application grows into 1500 to 2500 and growing too much more, and this is a great problem now since retrieving 2000 records (Only Retrieving) took me about 3 minutes. while some other page with extensive calculations on the 2000 records took exactly 7:30 minutes. As a test, I have switched to CGI, because I had the feeling that ISAPI has something to do with it, and it took exactly 2 seconds to retrieve 2500 records! so now i am positive that ISAPI has something to do with that draw back! maybe there is some settings between ISAPI - MSSQL - ISS that i should fix! because using CGI is not an option at all because of the frequent (The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:) errors i had, especially in multi-frames pages with MSSQL actions. I have tried versions PHP 4.3.3 until 4.3.6, same trouble. Thanks for listening to our troubles :) ------------------------------------------------------------------------ [2004-10-08 17:24:24] john at appliedgroup dot com I am having the same issue with W2K3/IIS and mysql. Same problem with php 4.3.7 and 4.3.9 Even weirder is that only some systems on the network were affected???? Changing to CGI speeded everything up. ------------------------------------------------------------------------ [2004-06-08 23:35:27] andy at advancethermal dot com Experiencing the same problem with WindowsXP / Apache 2.0 / PHP 4.3.7 / MS SQL Server 2k (Evaluation Version). Queries take about 3-4x longer through mssql_query than odbc_exec. ------------------------------------------------------------------------ [2004-06-02 16:38:39] michael dot lidgren at cypoint dot se Description: ------------ SQL queries take several seconds under the ISAPI module; with the same queries taking virtually no time at all using the CGI module. Same .ini, same everything except ISAPI vs CGI. W2k3/IIS, PHP 4.3.6 Reproduce code: --------------- mssql_connect(...); mssql_query("SELECT * FROM any_table"); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28610&edit=1