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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Mengu Yazicioglu changed: What|Removed |Added CC||me...@devinim.com.tr --

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 sbar...@aacpl.net changed: What|Removed |Added CC||sbar...@aacpl.net ---

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Andreas Jonsson changed: What|Removed |Added See Also|

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Andreas Jonsson changed: What|Removed |Added CC|

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Martin Renvoize changed: What|Removed |Added CC|

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #20 from Julian Maurice --- Comment on attachment 154331 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=154331 Bug 33554: [WIP] Add a new lookup endpoint for patron searching Review of attachment

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Julian Maurice changed: What|Removed |Added Status|In Discussion |Failed QA --- Comment #19

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #18 from Didier Gautheron --- (In reply to Jonathan Druart from comment #17) > Didier, Julian, can you have a look at this patch and test it? For real life test we only have < 22.11.06 customers and patch doesn't

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #17 from Jonathan Druart --- Didier, Julian, can you have a look at this patch and test it? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Liz Rea changed: What|Removed |Added CC||wizzy...@gmail.com --- Comment

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #15 from Nick Clemens --- If this approach looks reasonable then I will write tests, and update to fix the attribute search. Just let me know if I should put this time in -- You are receiving this mail because: You are

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #14 from Kyle M Hall --- (In reply to Jonathan Druart from comment #13) > We can also resurrect bug 17500... I think that's the best idea. It's gonna take time though, assuming you are interesting in picking it back up.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 koha-US bug tracker changed: What|Removed |Added CC||bugzi...@koha-us.org

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Rebecca Coert changed: What|Removed |Added CC||rco...@arlingtonva.us --

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #13 from Jonathan Druart --- We can also resurrect bug 17500... -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #12 from Kyle M Hall --- I feel like we could greatly simplify and speed up patron searching by simply have a new table column or columns that exist solely to contain searchable content. We could even store this in JSON

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #11 from Nick Clemens --- Created attachment 154331 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=154331=edit Bug 33554: [WIP] Add a new lookup endpoint for patron searching This patch adds a new API

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #10 from Nick Clemens --- 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

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #9 from Tomás Cohen Arazi --- (In reply to Julian Maurice from comment #6) > (In reply to Jonathan Druart from comment #4) > > I was going to suggest to have a separate "extended_attributes" parameter we > > could pass

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Tomás Cohen Arazi changed: What|Removed |Added CC||tomasco...@gmail.com

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Sally changed: What|Removed |Added CC||sally.healey@cheshireshared

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Jonathan Druart changed: What|Removed |Added Status|NEW |In Discussion -- You

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #7 from Jonathan Druart --- Tomas, any ideas how to fix this correctly? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 David Cook changed: What|Removed |Added CC||dc...@prosentient.com.au --

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Julian Maurice changed: What|Removed |Added CC|

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Kyle M Hall changed: What|Removed |Added CC||k...@bywatersolutions.com

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Jonathan Druart changed: What|Removed |Added CC|

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #3 from Nick Clemens --- Would it be reasonable if making an attribute searchable didn't mean it was searched by default? i.e. we could add the attribute to the search dropdowns, or have an option on the attribute to

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 --- Comment #2 from Didier Gautheron --- (In reply to Nick Clemens from comment #1) > An index on those tables might help - we saw similar issues on a site with > many borrowers. In my understanding these tables are already fully

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community