summaryrefslogtreecommitdiffstats
path: root/web/README
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2009-04-11 23:40:58 +0200
committerLoui Chang <louipc.ist@gmail.com>2009-06-18 07:47:17 +0200
commit1ceeda8ab529ba0ba04664621e9edb5f4dfae397 (patch)
tree74a14ac43d64c17a14271fdabb056b634e61f0d6 /web/README
parente2b3bd1c37d91a747e8f774bbb91aad3dc466c68 (diff)
downloadaur-1ceeda8ab529ba0ba04664621e9edb5f4dfae397.tar.gz
aur-1ceeda8ab529ba0ba04664621e9edb5f4dfae397.tar.xz
Specify explicit joins for package search
Refactor the query to use explicit LEFT JOINs, which appears to be handled by MySQL in a saner fashion than the previous implicit join syntax. This is part two in a slight fixup for observed slow queries in the production environment. With the new indexes and this fixup, a particular iteration of this query will examine only 13346 rows instead of 272060. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Diffstat (limited to 'web/README')
0 files changed, 0 insertions, 0 deletions