Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database connections #1595

Open
Changaco opened this issue Oct 7, 2019 · 0 comments
Open

Database connections #1595

Changaco opened this issue Oct 7, 2019 · 0 comments
Labels
DevX making it easier to develop and maintain Liberapay performance issues about improving efficiency and speed

Comments

@Changaco
Copy link
Member

Changaco commented Oct 7, 2019

The way we currently interact with the database is inefficient: we're taking a connection out of a pool for almost every query we send to the database. Instead, we should use a single connection per HTTP request. In addition to being more efficient, this would make it easy to count the SQL queries we send while processing an HTTP request and to measure the time spent waiting for the results.

(Related issues: #1548 and #1587.)
@Changaco Changaco added DevX making it easier to develop and maintain Liberapay performance issues about improving efficiency and speed labels Oct 7, 2019
@Changaco Changaco mentioned this issue Mar 12, 2020
Closed
@Changaco Changaco mentioned this issue Mar 23, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
DevX making it easier to develop and maintain Liberapay performance issues about improving efficiency and speed
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Changaco