[Koha-bugs] [Bug 14320] New: Improve the speed of the checkouts table loading items with many holds and items using AllowRenewalIfOtherItemsAvailable

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

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

            Bug ID: 14320
           Summary: Improve the speed of the checkouts table loading items
                    with many holds and items using
                    AllowRenewalIfOtherItemsAvailable
 Change sponsored?: ---
           Product: Koha
           Version: 3.18
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Circulation
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: kyle at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

The feature AllowRenewalIfOtherItemsAvailable can take a tremendous amount of
processing for records with large numbers of holds and/or items. For example,
for a record with 50 items and 100 holds we must call a series of subroutines
5000 times!

The loop this processing takes place in has an outer loop of borrowers and an
inner loop of items. However, two of the three subroutines only need an
itemnumber. So, if we move the items loop to be the outer loop, we can 'cache'
these subroutine calls and vastly improve the speed of the subroutine.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.