]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 35b8222) | patch
LP#1615736 - Add an index on the usr field of action.usr_circ_history.
authorJosh Stompro <stomproj@larl.org>
Mon, 29 Aug 2016 19:07:48 +0000 (14:07 -0500)
committerGalen Charlton <gmc@esilibrary.com>
Wed, 16 Nov 2016 16:47:00 +0000 (11:47 -0500)
commit09f45b56fb72335817c087052bb1b50be0bf3bb6
tree5ab289c45c6d3614a9f50c5160b17b363735289ctree
parent35b822231a40bcf7e6e68e17bb28a15337e49879commit | 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