]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 422ef95) | patch
LP#1643932 - Fix search slowness when patron searching by username
authorChris Sharp <csharp@georgialibraries.org>
Mon, 5 Dec 2016 22:46:02 +0000 (17:46 -0500)
committerGalen Charlton <gmc@equinoxinitiative.org>
Tue, 14 Feb 2017 14:17:44 +0000 (09:17 -0500)
commita33fcc42f8f2cd9e1b578cf296ecc2b1712e1e2f
tree0126c3eabdad39c45d63323a947b79cddacd371ftree
parent422ef9560227739be2c90d3af7434965e9ab1707commit | diff
LP#1643932 - Fix search slowness when patron searching by username

Bug 1501781 introduced a feature to improve patron name searching,
but which was causing very slow queries when searching by username.
Adding an index to username solves the slowness problem.

Suggested by Mike Rylander.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/src/sql/Pg/005.schema.actors.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor_usr_usrname_unaccent_idx.sql [new file with mode: 0644] blob
Evergreen ILS