diff options
author | Dan McGee <dan@archlinux.org> | 2011-03-02 15:35:39 +0100 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-03-10 18:16:00 +0100 |
commit | c34bebf42859019998c7ff3c03b570295ae83ebe (patch) | |
tree | be0e6b04cd45a967b8ec71dc86aba8cc5c7455e7 /scripts/cleanup | |
parent | 2cfcddf24e4f1f20b70b300111bd92d77c0e2471 (diff) | |
download | aur-c34bebf42859019998c7ff3c03b570295ae83ebe.tar.gz aur-c34bebf42859019998c7ff3c03b570295ae83ebe.tar.xz |
Perform a second query to find total search count
This removes the need for SQL_CALC_FOUND_ROWS which can really slow down
queries in a lot of cases. The COUNT(*) query we end up performing can
reuse a lot of the original clauses from our primary query, but we can
really slim it up by omitting some joins and the sorting/limiting
clauses.
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'scripts/cleanup')
0 files changed, 0 insertions, 0 deletions