[Koha-bugs] [Bug 6801] C4::Overdues::checkoverdues returns all fields from biblio, biblioitems, items and issues

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Sep 1 00:46:59 CEST 2011


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

--- Comment #3 from Ian Walls <ian.walls at bywatersolutions.com> 2011-08-31 22:46:59 UTC ---
More research has led to the REAL root of the problem Liz is experiencing; it's
not so much that checkoverdues is inefficient, but that it's being called WAY
too often now that Relatives Checkouts are in place (it's called once for every
issue checked out to the person or to their relatives).

On this particular issue, however, looking at how the returned values of
checkoverdues are actually used, we only need to return itemnumber and date_due
from the issues table (or anything extra we'd like to show over a SIP2
connection, once that functionality is added).  This would greatly shorten the
query time, which is never a bad thing.

-- 
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