projects / contrib / Conifer.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 30abb31) | 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:20 +0000 (11:47 -0500)
commit1e59d99993db01b29ae7e7a36b7062f3c3816f1c
tree3d85b7bb992d7387bd4dc155f502df26dc523937tree
parent30abb31d8fb3d9be289db89c801af623f069b122commit | 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 contribs