]> git.evergreen-ils.org Git - Evergreen.git/commit
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:59 +0000 (15:29 -0400)
commit73c08ceb56c1f707ab367375b3ea9e3a57823ea6
tree30f3bb660e3537d974bec5e779eccb2e5d81c03d
parent3f0d3f8edffbdd323f23c7a8b86b7689b43435a6
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
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usrname_index.sql [new file with mode: 0644]