projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c6f486f) | patch
LP#1615736 - Add an index on the usr field of action.usr_circ_history. user/gmcharlt/lp1615736_auch_usr_index_signedoff
authorJosh Stompro <stomproj@larl.org>
Mon, 29 Aug 2016 19:07:48 +0000 (14:07 -0500)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 28 Oct 2016 20:07:19 +0000 (16:07 -0400)
commit1b2ec31893bdcec2d873fe48d59337c7f1053e3c
tree9a6683170622504751f5c07985328050d10fad46tree
parentc6f486fd1bce40f722b2072cef69e59ac6df678bcommit | diff
LP#1615736 - Add an index on the usr field of action.usr_circ_history.

Improve the performance of looking up a users circ history by adding
an index on action.usr_circ_history( usr ).

To test for performance improvements time doing a search for a particular
users history before and after the index is created.

Signed-off-by: Josh Stompro <stomproj@larl.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/090.schema.action.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.action_usr_circ_history_index.sql [new file with mode: 0644] blob
Evergreen ILS