http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9811
--- Comment #47 from Galen Charlton <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
