[Koha-bugs] [Bug 29134] Patron search has poor performance when ExtendedAttributes enabled and many attributes match

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Sep 29 15:09:55 CEST 2021


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

Jonathan Druart <jonathan.druart+koha at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart+koha at gmail.
                   |                            |com

--- Comment #3 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
(In reply to Jonathan Druart from comment #2)
> Created attachment 125453 [details] [review]
> Bug 29134: [ALTERNATIVE patch] Keep filter_by_attribute_value
> 
> And build the IN using the existing @matching_borrowernumbers.
> We have a method for that, we should not use raw SQL.

~600-700ms with Nick's patch
22s on master
~600-700ms with this alternative patch.

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


More information about the Koha-bugs mailing list