[Koha-bugs] [Bug 35439] Large background jobs can create delays

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

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

--- Comment #2 from Matt Blenkinsop <matt.blenkinsop at ptfs-europe.com> ---
I've actually got a start point for this in a piece of work I'm doing for
importing KBART files into ERM. The files can contain 10s of 1000s of titles
and quite often breach the max_allowed_packet in the database when you try and
store the args in the background_jobs table. I've got some subroutines that
chunk those files to make sure that we are never more than 75% of the
max_allowed_packet and enqueue chunked jobs based on those acceptable sizes.

They are still large and sometimes slow jobs though and they all just get
passed to the worker queue in order - how would you envisage the interleaving
of jobs?

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