[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 #75 from Josef Moravec <josef.moravec at gmail.com> ---
(In reply to Nick Clemens from comment #72)
> (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

There is in fact no need to select all itemnumbers from checkouts...

I added a follow-up, for me it is now significantly faster, even something like
10 times faster then before, could you test on your data?

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