[Koha-bugs] [Bug 33554] searching borrowers is a lot slower if there's searchable extended attributes.

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

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

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kyle at bywatersolutions.com

--- Comment #5 from Kyle M Hall <kyle at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #4)
> I was going to suggest to have a separate "extended_attributes" parameter we
> could pass to the endpoint, but that's not trivial to implement (we need the
> search_type, and to know if we need a OR or AND with q...)

what about storing searchable attribute values in a new borrowers column? Any
time a searchable attribute is modified, we would just regenerate the text for
that column. Then we would no longer need to join on the attributes tables.

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