I'm having some trouble getting PHP to run on my server 2008 box efficiently. The server is running on ESX with 3 allocated processors.
The php-cgi.exe process is taking up 100% of the processor time bringing the server to a slow crawl. I've set the max instances to 2 so that it only maxes out 2 of the 3 processors. This leaves enough overhead to work on the server without waiting 5 minutes for IIS manager to open.
I've installed WinCache and configured FastCGI and I've still not have seen any improvement. I'm kind of stuck here. Any ideas you have would be appreciated.
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.