diff options
| author | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-10-03 22:49:19 -0400 |
|---|---|---|
| committer | Kelly Rauchenberger <fefferburbia@gmail.com> | 2017-10-03 22:49:19 -0400 |
| commit | 353b170392892a1f9bdde74550112b5131c99fd2 (patch) | |
| tree | 46305a7d5fc40c4a70a7fd7615a0e549730605ec /lib | |
| parent | 4bc96847f621c4cb3940fe99b3b4b67b20596189 (diff) | |
| download | pokeviewer-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 'lib')
0 files changed, 0 insertions, 0 deletions