Adding PostgreSQL support to avoid database locks #4

Closed
opened 3 years ago by neil · 1 comments
neil commented 3 years ago
Owner

SQLite isn't optimized enough. Some requests ends up rejected because of the database lock.

It happens way less often than before #1 fix, but still happens, though it seems to affect less than 0.1% of the requests.

https://stats.42l.fr/reports/weekly/2020/18/all/rs-short.html

Offering the possibility to migrate to PostgreSQL would help.

SQLite isn't optimized enough. Some requests ends up rejected because of the database lock. It happens way less often than before #1 fix, but still happens, though it seems to affect less than 0.1% of the requests. https://stats.42l.fr/reports/weekly/2020/18/all/rs-short.html Offering the possibility to migrate to PostgreSQL would help.
neil added the
priority:low
enhancement
labels 3 years ago
neil commented 2 years ago
Poster
Owner

Very easy to do with Diesel. No big changes to the code are needed.

Very easy to do with Diesel. No big changes to the code are needed.
neil referenced this issue from a commit 1 year ago
neil closed this issue 1 year ago
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: 42l/rs-short#4
Loading…
There is no content yet.