[Koha-bugs] [Bug 26802] Improve speed with records with many items

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

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

--- Comment #7 from David Cook <dcook at prosentient.com.au> ---
(In reply to Björn Nylén from comment #2)
> We've done some profiling to figure out where the delay is. The problem is
> mainly that in the XSLT processing an auth. value description is looked up
> in the db for every item column. Caching the values will have a big effect. 
> Branch- and itemtypenames for items are also looked up per item and will
> slow down the detail pages from what we've seen.

I've noticed other issues in the XSLT processing as well, especially in
C4::XSLT::buildKohaItemsNamespace().

It does a huge number of database calls, and when you have thousands of items,
it's just going to be slow no matter what.

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