projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e07ac6c) | patch
LP#1615736 - Add an index on the usr field of action.usr_circ_history. user/stompro/lp1615736_action_history_usr_index
authorJosh Stompro <stomproj@larl.org>
Mon, 29 Aug 2016 19:07:48 +0000 (14:07 -0500)
committerJosh Stompro <stomproj@larl.org>
Mon, 29 Aug 2016 19:07:48 +0000 (14:07 -0500)
commit8e94b3f59297b1c5c7beef6e371be7de0d8a7f50
tree32ff632627cdc054f07d586dff05f58f6f3ca532tree
parente07ac6c32679a87ecf2dcc5c4c11a01347871313commit | 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>
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