Thought I'd start a new thread for this although discussing best setup for databases here.
My server was initially setup on CGI which was apparently causing major problems.
Had a systems administrator checkout my setup and recommended the following:
1. Switch from CGI to mod_php
2. Move .htaccess content to apache server config
3. Setup NGINX as reverse proxy in front of apache
4. Setup eAccelerator
CGI to mod_php has some problems but can be done.
But my host refuses to work with NGINX and all my support kinda stops at that.
So is that the best way to go?
What's the next best alternative working without it or are there any other configurations to go by?