https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33489 Bug ID: 33489 Summary: The borrowers table should have indexes on default patron search fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org While a library can specify the default patron search fields in the similarly named preference, DefaultPatronSearchFields, Koha should ship with indices on the default fields: firstname,middle_name,surname,othernames,cardnumber,userid These exist for firstname, surname, and othernames We have seen the basic patron search take between 2-4 seconds without these indexes on a database of 700k patrons. When using only the indexed fields, the search takes 6 milliseconds In testing with 100k patrons I saw a reduction after adding the indices from half a second to ~1 centisecond -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.