projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9322d41) | 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)
committerChris Sharp <csharp@georgialibraries.org>
Mon, 19 Dec 2016 23:16:37 +0000 (18:16 -0500)
commit92d9f0c61e4cb81c540d3ea0efb3ff690999b96d
tree38fad2acb6356eb75671b00013ac01270756a2cftree
parent9322d41b291f439d8252a6eb9b338c9ba32518a8commit | 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 working repo (PINES)