LP#1588543: Speed up record attribute ingest
authorDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2016 18:36:29 +0000 (14:36 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 9 Aug 2016 16:01:53 +0000 (12:01 -0400)
commitcf3bd149e53585676a517d38093f2470dbcfaaeb
treef80bc14c38dca4a968bb7ee525f67e2a9526354c
parentb55b3cafbb9c64c39b1ad1fbbc0074066d616bba
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>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/030.schema.metabib.sql