http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13645
--- Comment #6 from Jacek Ablewicz <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
