https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42835 --- Comment #33 from Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> --- Created attachment 202486 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=202486&action=edit Bug 42835: (follow-up) Cache items index queries for availability and facets _get_available_biblionumbers() and _get_item_facets() hit the items index on every search, unscoped and uncached. Fine on a small catalog, brutal at real scale - hundreds of round-trips per "available" search. Cache both for 15s. Single key for availability (same result for everyone); MD5-of-biblionumbers key for facets (result is per-search). Test plan: 1) prove t/db_dependent/Koha/SearchEngine/Elasticsearch/Search.t 2) Run demo_cache_fix.pl - second call to each function should be near-instant vs the first Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> -- You are receiving this mail because: You are watching all bug changes.