ID: 28610
Comment by: i_know_u21 at yahoo dot com
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:
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 :)
Previous Comments:
------------------------------------------------------------------------
[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
