http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14736 Bug ID: 14736 Summary: AllowRenewalIfOtherItemsAvailable slows circulation down in case of a record with many items and many holds Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: hbraum@nekls.org QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com This issue was originally reported in bug 14320. If the AllowRenewalIfOtherItemsAvailable sys pref is set to allow, and a borrower has an item checked out that has many items {30+} AND many holds {70+) on it, loading the checkouts table for this borrower takes FOREVER to load. The load time takes forever, because of the factoring that happens to determine if an item is truly available for renewal. At this time, the situation couldn't be improved in bug 14320, but I want this report out there, in case this becomes a bigger problem and/or someone comes up with a way to speed up the processing. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.