https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42835
--- Comment #33 from Pedro Amorim (ammopt) <[email protected]> --- 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 <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
