about summary refs log tree commit diff stats
path: root/app/assets/config
diff options
context:
space:
mode:
authorKelly Rauchenberger <fefferburbia@gmail.com>2017-10-03 22:49:19 -0400
committerKelly Rauchenberger <fefferburbia@gmail.com>2017-10-03 22:49:19 -0400
commit353b170392892a1f9bdde74550112b5131c99fd2 (patch)
tree46305a7d5fc40c4a70a7fd7615a0e549730605ec /app/assets/config
parent4bc96847f621c4cb3940fe99b3b4b67b20596189 (diff)
downloadpokeviewer-353b170392892a1f9bdde74550112b5131c99fd2.tar.gz
pokeviewer-353b170392892a1f9bdde74550112b5131c99fd2.tar.bz2
pokeviewer-353b170392892a1f9bdde74550112b5131c99fd2.zip
Optimized front page queries
Reduced the number of queries that the front page runs to 2 queries
total: one to get trainer data, and one to get the Pokémon. The latter
query selects only the necessary columns, notably ignoring basically
everything from the revisions join other than the nickname of the most
recent revision. The controller then does the work of chunking the
Pokémon into party/boxes, and then into trainers/unaccounted.

refs #2
Diffstat (limited to 'app/assets/config')
0 files changed, 0 insertions, 0 deletions