If your PHP/MySQL site takes long to load, or process requests there are some things you may do outside of script optimization.
- Make sure you are using the server's local host name and not the IP address for the connection string. (i.e. mysqlvX instead of 205.178.146.XX)
- Optimize your MySQL tables by use of a PHP script or PHPMyAdmin. You can even make a scheduled task to do this on a daily basis in your account manager!
If anyone else has any tips please feel free to post a reply!