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

DBIx::Class is the same as using plain DBI. So the speed gain doesn't come from
the plain SQL (you could write the same query using the SQL::Abstract syntax
DBIC uses), but from the fact that you are using a more fine-tuned approach on
the query, to get all data at the same time.

What I think Jonathan is saying, is that we need to solve this in a way that
doesn't break our object system for the rest of the functionalities. I will try
to think about it today too.

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