LP#1588543: Speed up record attribute ingest
authorDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2016 18:36:29 +0000 (14:36 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 29 Jul 2016 15:19:24 +0000 (11:19 -0400)
commitf4ef3bfd561dbee9943a51f42f710fc5b19e492c
tree780a6017e95c87c4e9c722a5f8f34d8fe0804096
parent357aabae410bbe25160947acd52693841d690e92
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