Speed up record attribute ingest
authorDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2016 18:36:29 +0000 (14:36 -0400)
committerDan Wells <dbw2@calvin.edu>
Wed, 1 Jun 2016 18:36:29 +0000 (14:36 -0400)
commit116546b2c8378d089c299ab64837522ceff03ce4
tree86038a7c26c63f0c990dd619af7e8aac76e591aa
parent7c14ceaa42f409cc7a58acf4d0bbc167beb6b883
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 7x speedup).

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