[Koha-bugs] [Bug 29507] Speed up auto renew cronjob via parallel processing

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Nov 17 18:45:32 CET 2021


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

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #127743|0                           |1
        is obsolete|                            |

--- Comment #2 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 127744
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127744&action=edit
Bug 29057: Speed up auto renew cronjob via parallel processing

The cron can take a very long time to run on systems with many issues. For
example, a partner with ~250k auto_renew issues is taking about 9 hours to run.

If we run that same number of holds in 5 parallel chunks ( splitting the number
of issues as evenly as possible, it could take under 2 hours.

Test Plan:
0) Install the Perl library Parallel::ForkManager
1) Generate a number of issues marked for auto_renew
2) Run the automatic_renewals.pl, use the `time` utility to track how much time
it took to run
3) Set parallel_loops to 10 in auto_renew_cronjob section of config in
koha-conf
4) Repeat step 2, note the improvement in speed
5) Experiment with other values

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


More information about the Koha-bugs mailing list