[Koha-bugs] [Bug 9811] Patrons search improvements

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9811

--- Comment #47 from Galen Charlton <gmcharlt at gmail.com> ---
(In reply to Jonathan Druart from comment #43)
> Maybe the executing time issue is caused by the 2 COUNT(*) queries. But
> since we don't want the "SELECT SQL_CALC_FOUND_ROWS" mysqlism, I don't know
> how we can do that on a different way.

And FWIW, even if we allowed the MySQLism, it might not actually be any faster
than running two queries:

http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/

That blog post is pretty old, of course, so things may have changed, but
benchmarking would be in order either way.

-- 
You are receiving this mail because:
You are watching all bug changes.