[Koha-bugs] [Bug 20664] Optimize retrieval of biblio and item data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |In Discussion

--- Comment #84 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
+    # This is so much faster than using Koha::Items->search that it makes
sense even if it's ugly.
+    my $query = 'SELECT * FROM items WHERE biblionumber = ?';

Patch still applies.
If I am reading thru the comments above, the main point of discussion is now:
Do we want to return to raw sql in the above lines? It is rather obvious that
this is faster than Koha::Object/DBIx. But we made a choice for DBIx and are
still wrestling to implement it in the codebase. What would be the decisive
reason for making the exception here, and would it be a precedent for doing
similar things elsewhere? Also note that although the test plan refers to
verifying that things are faster, I do not see any benchmark figures on the
report.

Moving to discussion and sending mail to QA.

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