Adding PostgreSQL support to avoid database locks #4

Open
opened 1 year ago by neil · 1 comments
neil commented 1 year 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 1 year 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.
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
There is no content yet.