[Koha-bugs] [Bug 39618] Add a non-unique index/key to borrowers table for preferred_name

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39618 --- Comment #4 from Lucas Gass (lukeg) <lucas@bywatersolutions.com> --- (In reply to David Cook from comment #2)

That's really interesting.

Can you explain the patch a bit more?

Without an index a search on the borrowers table for 'Bri', 'Bria', or 'Brian' will read through every row checking each 1 by 1. With an index the DB lookup starts with 'Bri', 'Bria', or 'Brian' as a starting point and is much faster. I mention 'Bri', 'Bria', or 'Brian' because these may all be lookups w/ the autocomplete feature as you continue to type the name 'Brian', letter by letter. -- You are receiving this mail because: You are watching all bug changes.