]> de.git.xonotic.org Git - xonotic/xonstat.git/commit - xonstat/views/submission.py
Don't put anonymous players in games.players
authorAnt Zucaro <azucaro@gmail.com>
Sat, 7 Nov 2015 15:15:54 +0000 (10:15 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Sat, 7 Nov 2015 15:15:54 +0000 (10:15 -0500)
commit0b3f0a95e5999966940d50c9e6861a8fb9d1765c
tree0fde24c6940fb76456889887b2e7f25ff004c7ae
parente8e0da3896ca31071f975141aaf5dd59cc82f2db
Don't put anonymous players in games.players

The "games" table has a convenience, de-normalized column for storing the list
of player_ids who played in that game. This is intended for use in quick
searches. Since anonymous players (players having a player_id == 2) aren't
searchable, they don't need to be in this list. This should decrease the
overall size of the GIN index on that column over time.
xonstat/views/submission.py