[Koha-bugs] [Bug 23035] Intranet search is slow if thousands of items are in the biblios shown in the search results

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

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

--- Comment #3 from Emmi Takkinen <emmi.takkinen at koha-suomi.fi> ---
(In reply to Jonathan Druart from comment #1)
> A quick and (hopefully) efficient change would be to replace the SELECT from
> authorised_values by a call to C4::Koha::GetAuthorisedValues (the cache is
> used there).

This does indeed improve search speed quite a bit. Tested this in test
environment where biblios usually have from ten to thousand items and in most
cases search time was halved. 

I think this change along side with syspref introduced in bug 28373 would be a
good start to make search work faster.

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