0

We have a globally available application that uses a SQL database. We have a fairly low number of users and load on database is low, however latency for users located far from the database server is a bit of a concern. I'm looking for an advice on recommended best practices and techniques to minimize latency and enhance overall performance in this scenario. What strategies should we consider implementing to optimize performance and reduce latency in our globally accessible application, given the low user count and low database load?

Improve this question
1
  • 2
    Use few bigger statements rather than many small ones. Use pipeline mode wherever possible.
    – Laurenz Albe
    Commented Jun 5, 2023 at 14:05

1 Answer 1

Reset to default
0

Try to use a connection pool from the application side or from database side (ex: PGBouncer) and reuse existing connections to avoid keeping creating new ones. Then it is more network implementation. Keeping the database close to the clients is the best option for latency.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.