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@liblime.com ReportedBy: rch@liblime.com QAContact: koha-bugs@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.