]> git.evergreen-ils.org Git - contrib/Conifer.git/commit
LP#1588543: further speed up record attribute ingest
authorGalen Charlton <gmc@esilibrary.com>
Fri, 29 Jul 2016 15:24:07 +0000 (11:24 -0400)
committerDan Scott <dscott@laurentian.ca>
Mon, 5 Sep 2016 00:43:56 +0000 (20:43 -0400)
commit44c03c693a9dce70ce6cf758df6fbaf53c7946de
treeb2c75a27263c5c81ca736c45ac15d3898746ba6e
parentff875801262460c8af6f78ec4c38fdac81a7296b
LP#1588543: further speed up record attribute ingest

Following a suggestion from Dan Wells, this patch adds
an index on config.coded_value_map(ctype). My testing shows
that the index by itself can halve the time required to
fully ingest a new record; in conjunction with the
change in the previous patch, full reingest time is
reduced by about 60%.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/002.schema.config.sql