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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Aug 8 15:21:03 CEST 2023


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

--- Comment #10 from Nick Clemens <nick at bywatersolutions.com> ---
I am working on a 'patrons/lookup' endpoint to see about building the query in
a more performant way.

For testing, I imported 100k borrowers with several attributes each and was
able to confirm the slowdown when attributes are enabled

I dumped the tables and made them available on github:
https://github.com/kidclamp/sample_files/blob/main/many_attributes.gz
https://github.com/kidclamp/sample_files/blob/main/many_borrowers.gz

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


More information about the Koha-bugs mailing list