projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ce774bd) | patch
LP#1200735: improve performance of patron search by username
authorGalen Charlton <gmc@esilibrary.com>
Fri, 12 Jul 2013 19:10:32 +0000 (15:10 -0400)
committerBill Erickson <berick@esilibrary.com>
Fri, 12 Jul 2013 19:29:21 +0000 (15:29 -0400)
commit83ab50aab41e5a06dd237fbe9ac4cd0766689991
treecda731a444dbcdfd92e6a03a2d296ab728884e19tree
parentce774bd40ce04bea96c14c9d4a2d4fc9fdc26aa3commit | diff
LP#1200735: improve performance of patron search by username

This patch adds an additional index on actor.usr.usrname.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/005.schema.actors.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usrname_index.sql [new file with mode: 0644] blob
Evergreen working repo (Equinox)