[Matchmaking] Add index to improve searching for oldest open games
Opened this issue · 0 comments
dtest commented
The query to get a random open game before closing the game does a full table scan. This can be improved by adding the following index:
CREATE INDEX FinishedGames ON games(finished, created DESC);