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