Posted by Chung Leong on 04/05/06 07:32

davemateer@gmail.com wrote:
> Hi
>
> We have a current system:
>
> Linux / Apache / PHP4.x talking to Microsoft SQL 2000
>
> Thinking about going to:
>
> Windows 2003 / PHP4.x talking to the same Microsoft SQL 2000 box...
>
>
> Any pain that you have gone through? We will have some relatively high
> load, and complex queries going through the database driver.

Here's my experience running Apache 2.0 and PHP 4 on Win2K Server:

* Our parallel testing server got completely hosed once. My former
superior had decided that it was okay to run PHP in suicidal mode (i.e.
as CGI). Now I'm in his position :-j

* Ran into a thread-safety bug in 4.3.6 using custom stream wrappers. I
believe it's fixed in 4.3.9 or 10.

* Discovered that the Apache 2 SAPI was leaking one byte for every byte
outputted. Didn't really notice it at first, since Apache restarts the
handler process occasionally. The server started to experience massive
slow-down though after I wrote a script for generating ISO images.
Things returned to normal when I swapped it the SAPI module from 4.3.9.

* Traced another server stability problem to a rogue XSLT script.
Because the web server is multithreaded rather than multiprocess, when
the XSLT engine crashes in one request handler, all other handlers die
too.


We use MSSQL as well and I haven't had any problem with the mssql
functions thus far--except for the 255-character varchar limitation.

[Back to original message]