What are the performance implications of having a web server (apache/php) and a database server (mysql) in completely different locations with different hosts.
Edit: Its a database intensive web application so every page makes multiple trips to the database. The database is normally the bottle neck in web applications, just wondering if the network speed is significant when compared to the typical speed of database interactions.
Best Answer
This is highly dependent on the connection speed between the two locations. Some companies have high speed backbones between their data centers but from the sounds of it you are looking at two different companies. Since the connection is going across the internet and lines outside the control of either company then there is no solid answer to this question.
I would avoid it if at all possible. If you really feel this is the best approach look into something like memcache to alleviate querying from the DB.