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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
