https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24488
--- Comment #72 from Nick Clemens <n...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/