[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 #16 from David Gustafsson <glasklas at gmail.com> ---
Just to clarify, the performance gain comes from using DBI directly.
DBIx::Abstract could potentially be faster then DBIx::Class::ResultSet::search,
but in my opinion not much is gained by the abstraction for such a simple at
static query.

If you are saying that the speed gain mainly comes from loading multiple items
at once and not the low-level SQL, that is actually not the case as
demonstrated by the previous benchmark.

Loading multiple items with search (10 at the time) takes 50 seconds.

Loading multiple items (10 at the time) with pure-SQL 7.4 seconds.

And as previously noted, 10 items is pretty rare, so in practice the code using
search will produce an even worse result.

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