Add a clustered index on userId or gameId for UserGameResultModel and one on strategyId for GameDescriptionModel
Closed this issue · 2 comments
katanallama commented
Add a clustered index on userId or gameId for UserGameResultModel and one on strategyId for GameDescriptionModel
Daniil-Aleshechkin commented
The only way to do this is to add a collection on the prod db, so I'm just going to do it while deploying the mongo database
Daniil-Aleshechkin commented
Apparently you can only deploy mongo 5.0.0 on atlas and clustered indexes are only on 5.3. Not sure how to update the version on there, so I just created regular indexes. Makes inserts slightly slower, but it should be fine and virtually non noticeable for now