[Koha-bugs] [Bug 26587] detail.pl is very slow for records with many items

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

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

--- Comment #8 from Björn Nylén <bjorn.nylen at ub.lu.se> ---
Realised I had thing a bit mixed up, was testing a number of things at once.
Performance is also limited by some AV lookups in C4::Items::GetItemsInfo.
They should be cached in Memcached but I still get significan improvments when
caching them in a hashmap while looping the items.

Some figures from my testing:
Initial opac-detail.pl: ~20s
Only Branches patch: ~15s
Only GetItemsInfo patch: ~12s
Both: ~9s

We're using a separate db-server so may be more sensitive to db-access. Tesing
against that as we're interested in improving perf in our environment.

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