https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24488
--- Comment #75 from Josef Moravec <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
