[Koha-bugs] [Bug 28371] Improve performance of XSLTParse4Display

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

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

--- Comment #6 from David Cook <dcook at prosentient.com.au> ---
(In reply to Tomás Cohen Arazi from comment #5)
> We already have a cache for the frameworks, we should fetch all the avs and
> cache then based on the fw. It would be interesting to profile it.

Sounds good to me. And if we invalidate the AV cache based on the AV interface
in Administration, then that should be fresh.

> And speaking of scope, maybe it is time to think beyond C4. I haven't
> profiled it, but Nick's idea of Koha::Items->filter_by_visibility proved we
> can save lots of CPU cycles with better design. Previously, we called a
> method that queried item numbers, for then fetching each item in a loop (dbi
> era, GetItemsInfo).

+1

I've been doing a lot of non-Koha work on performance, and lookups on rarely
changed data in loops are so often the problem waiting to be fixed.

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