Hey guys, we are running into some performance issues with our database and digital ocean. We are using the app platform with a database that could use 97 connections but are scaling it up to 197. Would it be better to scale our pods horizontal to have more node applications with ~24 connections or scale the pods vertical so a single pod can hold up to 48 connections?

Hey Mark 👋 Did you try explicitly setting the connection_limit parameter in your database connection string and checking if you still run into performance issues? connection_limit would make sure that the connection pool will have exactly the number of connections that you specify.

👋 Hey @Mark, did you perhaps have a chance to check Nurul's answer? Let us know if you're still having issues!

Oh thanks for the response, I did not catch it. Yeah we set the connection_limit explicitly and it fixed the initial issue. We also discovered that we were not using the build-in dataloader solution for some of our queries. After refactoring we went from 140+ queries for a single request to ~40 requests.

That’s great to hear! Do let us know in case you face any other issues.