[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