[Koha-bugs] [Bug 29474] Automatic renewals cronjob is slow on systems with large numbers of reserves

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29474

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff

--- Comment #9 from Nick Clemens <nick at bywatersolutions.com> ---
5 renewals allowed
No renewal before unset (i.e. not before due)

For a single biblio
100 items on record
10 items checked out and marked auto_renew
10 record level holds

Without these patches:
~3.7 second

With these patches
~1.5 second


Then I set 'On shelf holds allowed' to 'If all unavailable'

Without these patches:
~3 MINUTES!

With these patches
~1.5 seconds

To further test 'ItemsAnyAvailable' I set all the items as overdue, changed
nothing else

Without these patches:
~3 minutes

With these patches
~1.25 minutes

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