summaryrefslogtreecommitdiffstats
path: root/scripts/cleanup
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2011-03-02 15:35:39 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-03-10 18:16:00 +0100
commitc34bebf42859019998c7ff3c03b570295ae83ebe (patch)
treebe0e6b04cd45a967b8ec71dc86aba8cc5c7455e7 /scripts/cleanup
parent2cfcddf24e4f1f20b70b300111bd92d77c0e2471 (diff)
downloadaur-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