[Koha-bugs] [Bug 33489] New: The borrowers table should have indexes on default patron search fields

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at 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.