I recently had to move my messageboard from a nix server to my Windows 2000 server at home. I am pleased with the setup for the most part. Luckily I don't have enough users for performance to be a real concern however sometimes it likes to slow down.
I've noticed that php.exe and mysqld will eat lots of CPU together on one simple request. Add multiple simple requests and you just complicate the problem.
Running PHP as an ISAPI is not an option as this likes to crash and cause other problems at times. I really don't consider it that much faster to begin with.
Is there any tweaking that can be done to help this problem?
I might be willing to run Apache but only if it solves the problem. I don't see how it would really because both Apache and IIS still have to call to php.exe so I don't believe it's a problem with the webserver itself, more like the win32 optimizations of php and MySQL.
Bottom line is... each request should not eat 100% of my CPU.
The box is a 600mhz Pentium III with 256 megs of ram running Windows 2000 Server w/sp 2 and the latest PHP and MySQL binaries as of yesterday morning.