[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 #17 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to David Gustafsson from comment #16)
> 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.

Can you profile it using ntyprof? I bet the bottleneck comes from
effective_itemtype when unblessing.

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