[Koha-bugs] [Bug 7886] C4/ShelfBrowser slow SQL performance
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Apr 6 19:10:14 CEST 2012
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7886
Dobrica Pavlinusic <dpavlin at rot13.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #8895|0 |1
is obsolete| |
--- Comment #7 from Dobrica Pavlinusic <dpavlin at rot13.org> ---
Created attachment 8976
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8976&action=edit
Bug 7886 - C4/ShelfBrowser slow SQL performance
ShelfBrowser uses two SQL queries with syntax
WHERE ((cn_sort = ? AND itemnumber < ?) OR cn_sort < ?)
AND homebranch = ? AND location = ? AND ccode = ?
homebranch already has index, and adding indexes on ccode and location
improves performance by 30% for each query since MySQL is able to use
index_merge intersect(items_ccode,homebranch,items_location)
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list