[Koha-bugs] [Bug 14736] New: AllowRenewalIfOtherItemsAvailable slows circulation down in case of a record with many items and many holds

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: hbraum at nekls.org
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at 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.