]> git.evergreen-ils.org Git - contrib/Conifer.git/commit
LP#1588543: Speed up record attribute ingest
authorDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2016 18:36:29 +0000 (14:36 -0400)
committerDan Scott <dscott@laurentian.ca>
Mon, 5 Sep 2016 00:43:52 +0000 (20:43 -0400)
commitff875801262460c8af6f78ec4c38fdac81a7296b
tree4db3edca0d159ab8581e8da3349dd321c9ab2490
parent2fe62ce84259eaec8b8e9751943657b05f8b8d48
LP#1588543: Speed up record attribute ingest

A huge number of rows (700+) have been added to
config.record_attr_definition in recent versions of Evergreen. However,
these rows do not actually define any indexing at all, but are used for
other purposes.  The reingest process currently churns over all of these
rows to ultimately do nothing.

This commit limits the group of attributes considered at ingest to only
those which might index something.  Testing indicates a substantial
speed boost to typical use of metabib.reingest_record_attributes()
(over 2x speedup).

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/030.schema.metabib.sql