diff options
| author | Dan McGee <dan@archlinux.org> | 2009-04-11 16:40:58 -0500 |
|---|---|---|
| committer | Loui Chang <louipc.ist@gmail.com> | 2009-06-18 01:47:17 -0400 |
| commit | 1ceeda8ab529ba0ba04664621e9edb5f4dfae397 (patch) | |
| tree | 74a14ac43d64c17a14271fdabb056b634e61f0d6 /support/scripts/newpackage-notify | |
| parent | e2b3bd1c37d91a747e8f774bbb91aad3dc466c68 (diff) | |
| download | aurweb-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 'support/scripts/newpackage-notify')
0 files changed, 0 insertions, 0 deletions