postgresql - Having backend and database on different data centers -


i developing web/mobile application , want host on 1 of cloud platforms. want keep backend/web application on heroku , want keep database (postgresql) on digitalocean. curious if there performance overhead separating backend , database. thanks.

performance impacted when putting distance between application , database, severity of impact dependent on 2 factors

  1. speed of connection between application , database.
  2. frequency of communication between application , database.

if application isn't data-reliant, can away separation without performance impact... if application needs read/write database every action user takes may start notice delays.

that said, it's not uncommon separate this, though suggest put 2 close can afford to.


Comments