http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5866
--- Comment #2 from Chris Cormack <[email protected]> 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. _______________________________________________ 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/
