https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24488 --- Comment #75 from Josef Moravec <josef.moravec@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.