https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19884 --- Comment #15 from Tomás Cohen Arazi <tomascohen@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.