[Koha-bugs] [Bug 5866] At larger hold volume, waitingreserves.pl for all libraries times out, can cause generalized slowness
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Aug 25 03:51:00 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5866
--- Comment #2 from Chris Cormack <chris at bigballofwax.co.nz> 2011-08-25 01:51:00 UTC ---
The problem here, is the query is this
SELECT borrowernumber,reservedate,itemnumber,waitingdate FROM reserves
WHERE priority='0' AND found='W';
With makes use of no indexes
CREATE INDEX priorityfoundidx ON reserves (priority,found);
Will create a composity key, which then will be used by the query which should
reduce the time taken to search a lot.
Will create a patch
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
More information about the Koha-bugs
mailing list