diff options
| author | Dan McGee <dan@archlinux.org> | 2011-03-02 08:35:39 -0600 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-03-10 18:16:00 +0100 |
| commit | c34bebf42859019998c7ff3c03b570295ae83ebe (patch) | |
| tree | be0e6b04cd45a967b8ec71dc86aba8cc5c7455e7 /scripts | |
| parent | 2cfcddf24e4f1f20b70b300111bd92d77c0e2471 (diff) | |
| download | aurweb-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')
0 files changed, 0 insertions, 0 deletions