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

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

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

--- Comment #4 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #3)
> (In reply to Jonathan Druart from comment #2)
> > Created attachment 125453 [details] [review] [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.

At 500k patrons with 100k attributes the alternate is a bit slower
The query can still be large (caharacter count) with the IN, and requires 2 db
calls, one for filter_borrowers_by_attribute, another to search the borrower DV

Moving to Objects is nice, but I think pure SQL here makes more sense than
mixing the two - I opened bug 29125 to remove all the SQL here

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