projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: cf3bd14) | patch
LP#1588543: further speed up record attribute ingest
authorGalen Charlton <gmc@esilibrary.com>
Fri, 29 Jul 2016 15:24:07 +0000 (11:24 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 9 Aug 2016 16:01:53 +0000 (12:01 -0400)
commit6cc1d1e0911f4dd4a92d17a9b60025888b080bff
tree737dbcd6f125a0b83d7ec121fe69f5b2f07ed5f8tree
parentcf3bd149e53585676a517d38093f2470dbcfaaebcommit | diff
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>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Evergreen ILS