Question

Managed DB become very very slow

When I connect my Laravel Application using the localhost MySQL then it’s work very fast. But when I do connect my Application to the Managed DB, it’s become 5 times slower. I really wants to use the managed DB but not slower of course.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Unfortunately this problem still persists and I cannot explain the problem to digital ocean. We couldn’t find a solution. I’m converting it to local. Don’t waste your time.

We just faced the same issue when migrating a complex application to digital ocean App Platform. We used a managed postgres DB with 1 vCPU and 2 GB RAM (30$/month) and got 4-8 times slower performance for expensive read queries compared to our old provider.

After replacing the managed DB with a droplet (see https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-22-04), the performance issue seems fixed. The droplet has 1 vCPU and only 1 GB RAM (6$/month), but performs 4-8 times better.

This should be looked into by the engineering team.

I spun up a 2nd tier cluster (1 vCPU, 2GB RAM @ $30/mo each) and imported a mysqldump that’s currently running on AWS RDS, on a similarly specd instance. I’m in the midwest USA, the RDS instance is in Virginia and the DigitalOcean instance is in New York.

Querying against a properly-indexed table with ~200,000 rows:

  • DigitalOcean: ~600ms for the 1st call, subsequent calls anywhere from 400ms to 1.2s.

  • AWS RDS: ~150ms for the 1st call, ~30ms for subsequent calls

Really disappointed, because I was hoping to migrate a couple of clusters to DigitalOcean where I’m running node.js using the App platform. I’m open to suggestions, as the pricing here is great and I imagine within the same datacenter the speeds may be just fine (from app to db).