projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 80761d4) | patch
LP#1643932 - Fix search slowness when patron searching by username user/csharp/lp1643932_slow_username_search_index
authorChris Sharp <csharp@georgialibraries.org>
Mon, 5 Dec 2016 22:46:02 +0000 (17:46 -0500)
committerChris Sharp <csharp@georgialibraries.org>
Mon, 5 Dec 2016 22:49:41 +0000 (17:49 -0500)
commit4da3ae738380e075eabb0b9f90fdf42af44c1603
tree70b994538fa72d7ca6c04a2ec01e0b0bc5957da9tree
parent80761d499d7c4cf67097a2cc9874f5ac15986bc9commit | 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>
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