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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23035 --- Comment #3 from Emmi Takkinen <emmi.takkinen@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.