dreamhost

As I mentioned in my previous post, the site was bottlenecked by having the Apache/PHP and MySQL servers on two separate machines. This is the standard setup at Dreamhost; even if you have a PS, the mysql part is hosted on a different server. So even if you don't have to share a machine with other websites hosted on Dreamhost, you're still sharing their network latency when the Apache/PHP server is communicating with the MySQL server. On a typical non-cached page, the IVRPA site makes 200-400 queries to the database.

Since the migration, the site has been having performance issues. While I had hoped that the site perfromed better with a newer version of Drupal, we're actually seeing worse performance.

The website has undergone another migration to a fresh new host. Unfortunately things were just not working out for us at mosso, and we're having to move in order to do what we want with the site.

This time our choice is Dreamhost, or more specifically Dreamhost PS. Their services have been tried and tested by the World Wide Panorama project. A big "thank you" to Markus Altendorff for sharing his experience.