[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