[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 #25 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
We, of course, know that an ORM will impact performance a bit.
I do not think the script you are testing to compare is fair, you are using the
DBMS cache as the query is always the same.
I think we should use a loop on all X biblionumbers, then retrieve the items
info.
With DBIx::Class::ResultClass::HashRefInflator, I'd expect more x4 instead of
x10, which is still to high, I admit.

If we have to provide a way to fetch a row from its id, I would prefer to
introduce a generic way (at Koha::Object level) to do it and use it only for
batch/heavy operations.

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