Imagine two cases:
- I have web server running in an EC2 instance and it is connected to the database in the RDS, the managed database service.
- I have web server and database running in the same EC2 instance.
Is my database in RDS going to be slower to access because it's not in the same machine?
How many milliseconds, approximately, does it add to your latency between the two?
Does this become bottleneck?
What about other managed database services like Azure, GCP, Digital Ocean, etc? Do they behave the same?