http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13645 --- Comment #6 from Jacek Ablewicz <abl@biblos.pk.edu.pl> --- (In reply to Jonathan Druart from comment #5)
Did you benchmark the scripts booksellers.pl and invoices.pl with this patch?
Patched master: 166 booksellers: - acqui/booksellers.pl: 1.3 sec - acqui/invoices.pl: 1.2 sec 1660 booksellers: - acqui/booksellers.pl: 6.4 sec - acqui/invoices.pl: 5.5 sec 16600 booksellers: - acqui/booksellers.pl: 55.8 sec - acqui/invoices.pl: 47.5 sec Unpatched master: 166 booksellers: - acqui/booksellers.pl: 4.06 sec - acqui/invoices.pl: 3.94 sec 1660 booksellers: - acqui/booksellers.pl: 33.2 sec - acqui/invoices.pl: 31.7 sec Test setup with pre-DBIx bookseller code (3.17.00.014), different server with ca 10-25% faster CPU, but otherwise rather similar software and hardware-wise: 166 booksellers: - acqui/booksellers.pl: 0.68 sec - acqui/invoices.pl: 0.61 sec 1660 booksellers: - acqui/booksellers.pl: 1.71 sec - acqui/invoices.pl: 0.64 sec 16600 booksellers: - acqui/booksellers.pl: 10.8 sec - acqui/invoices.pl: 1.16 sec Other difference between patched and unpatched master is that when running booksellers.pl on the unpatched master, CPU usage is 99+% for booksellers.pl and just 1.2-1.5% for mysqld, while for patched master it is ca 87% for a script and 12% for mysqld. Before filing this bug report I've tried to profile booksellers.pl with nytprof; there are some intriguing things in the results, for example: suspiciously high amount of CPU time (20% or so) is being spent in the various XML::* modules - I think I figured why it does that, separate bug report + patch will follow. -- You are receiving this mail because: You are watching all bug changes.