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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.

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.

Make sure your db node and app server node are in the same VPC. Digital Ocean has two default VPC’s: one on one side of the continent, one on the other, and if your application sends packets between the two internally, you may be observing significant latency in production. Moving all of your application components to one side of the continent should fix the problem. -piousbox