PHP 4.4.4, Apache 2.0.x and MS SQL 2005 SLOW/Performance Issues
Posted on 2006-10-27
We just moved from MySQL to MS SQL ... It was a group decision based on our dept. needs.
When we hosted MySQL previously it was on the same machine as Apache and was lightning fast.
Now that we've moved to MsSQL 2005 on a remote machine (still local network) with Apache our site are ALL super slow.
I have run any checks, but I have done some reading and it seems these is a common problem.
Pages w/o SQL are still quick and without delay. I'm not too found of the soon to become extinct DLL that allows for connectivity between PHP in Windows w/ Apache and MS SQL. But I don't think that's the problem (or could it be?).
Our PHP queries are simple... Select * which returns maybe 10 lines. I'd say it's at least twice as slow, if now worse.