[Koha-bugs] [Bug 13645] DBIx connection needs to be cached

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13645

--- Comment #6 from Jacek Ablewicz <abl at 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.