[Koha-bugs] [Bug 2634] New: details pages cause inefficient items query

bugzilla-daemon at pippin.metavore.com bugzilla-daemon at pippin.metavore.com
Tue Sep 23 20:52:30 CEST 2008


http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2634

           Summary: details pages cause inefficient items query
           Product: Koha
           Version: HEAD
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: P3
         Component: Architecture, internals, and plumbing
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: rch at liblime.com
         QAContact: koha-bugs at lists.koha.org


Items::GetItemsInfo is called by details pages on both staff and opac
interfaces, generating a query like 
SELECT * FROM items LEFT JOIN biblioitems.

This causes marc and marcxml data to be fetched once per item, and therefore
the 
item's marcxml actually is returned numitems^2 times.

In one case, with 320 item records, we get a 92M result set.

I'd like GetItemsInfo to not return marcxml or marc columns,
but need a code audit to make sure this won't break anything.

This bug is related to bug 2453 .

Suggest that fix be included in 3.0 maintenance release.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.



More information about the Koha-bugs mailing list