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:44:18 +0000 (11:44 -0500)
commit00692d6b4a022ed1c725b26b6daf373cf678b754
treed58495bb16d2ec99b88dcc969e4f74891eb9a9a0
parentabc63ac244d909e02886a428dc9a00666efd8742
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
Open-ILS/src/sql/Pg/upgrade/XXXX.action_usr_circ_history_index.sql [new file with mode: 0644]