By fidot on

Any comments on the following would be appreciated.

I am moving a Drupal 4.7 app to a new set-up for a client. This new set-up has its database on a different server to the website. The site is working ok.

Is this set-up necessarily slower than having the database on the same server as the website?

Thanks
Terry

Recent Drupal sites:-
http://www.route324.com, http://www.univarpcp.co.uk, http://www.businessclubagent.ihg.com/, http://www.businessclub.ihg.com/, http://www.imagineanimation.net

⋅ Categories: Drupal 4.7.x

Comments

avadhutp’s picture

avadhutp commented

Although the architecture—having the database on a different server—is more scalable, it will definitely lead to some decrease in the performance. This is coz' there is a base cost involved in having your application communicate with the database, as they exist on different physical hardware. So there is a network hop involved and a lot of address translation going on. In the end, we’re only talking about a handful of milliseconds, but that needs to happen for every query.

Read this for techniques on how to optmize installations of this nature: http://realjenius.com/node/577

fidot’s picture

fidot commented

... that what I thought happened, I was looking for confirmation

Thanks
Terry

Recent Drupal sites:-
http://www.route324.com, http://www.univarpcp.co.uk, http://www.businessclubagent.ihg.com/, http://www.businessclub.ihg.com/, http://www.imagineanimation.net

Recent Drupal sites:-
www.allegiantair.com www.defaqto.com www.quarkexpeditions.com www.sportrelief.com www.chevronhackles.com
www.philipturnercrafts.co.uk www.intelflexplus.com www.aprilroseturner.com www.businessclubagent.ihg.com www.businessclub.ihg