[Koha-bugs] [Bug 19884] Improve performance of GetItem

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884

--- Comment #14 from David Gustafsson <glasklas at gmail.com> ---
Hi! I'm not sure I understand, but where you thinking of skipping the pure-SQL
optimization but keeping the one loading multiple items at once using search
instead of find and then unblessing? Unfortunately that does not make that much
of a difference it seems.

I tried benchmarking with a biblio with 10 items (which is pretty rare, think
most of our biblios has only 1 or 2 items):

Loading each item separately took 372 seconds.

Loading multiple (10) items at once took 47 seconds: This is not bad (about 8
times faster, for 10 items, which is to be expected since results in 1/10 of
DBIx calls). Unfortunately since most libraries probably only have a couple of
items per biblio, averaging below 2, in practice the speedup is probably below
2 times faster.

With the pure SQL variant loading multiple items it took 7.4 seconds. 

All benchmarks where performed with item-level_types = 1, and loaded the items
20000 times.

I tried to make sure serials where not affected by adjusting the code for the
fethching of multiple items, and all tests passes (not sure if there are tests
for serials), but I could have another look at this.

-- 
You are receiving this mail because:
You are watching all bug changes.