[Koha-bugs] [Bug 24488] Holds to Pull sometimes shows the wrong 'first patron' details

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

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

--- Comment #72 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #63)
> I'd like someone to run a benchmark with and without this patch on a
> quite big database and see which approach is the best

I placed 1000 holds in my system:
INSERT INTO reserves
(borrowernumber,reservedate,biblionumber,branchcode,priority,itemnumber) SELECT
CEIL(rand()*50),CURDATE(),biblionumber,'CPL',1,NULL FROM biblio;

On master (strict mode disabled):
< 10s

Without discusson patch and followup:
> 1 min 20s

With discussion and followup:
< 50 s

While the follow-up offers great improvement, I am not impressed with the
slowdown overall

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