-
-
Notifications
You must be signed in to change notification settings - Fork 27
Open
Labels
importantIssues that should be focused onIssues that should be focused onrefactorCode that should be improvedCode that should be improved
Description
Limitations of MongoDB:
- Querying nested json data is really slow - this caused custom leaderboards to break at around 80k players
- Since MongoDB stores key/value pairs, it takes a lot of storage space
PostgreSQL's JSONB format allows us to store the same data taking less space and being faster to query.
One big downside is that a lot of the API functionality has to be rewritten, for example a lot of filtering relies on MongoDB's query language.
Checklist moved to PR
egorprnn, mew and Mythbusters123
Metadata
Metadata
Assignees
Labels
importantIssues that should be focused onIssues that should be focused onrefactorCode that should be improvedCode that should be improved