]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Reduce index bloat involving non-search_field values
authorBob Wicksall <bwicksall@pls-net.org>
Thu, 13 Jun 2013 05:06:10 +0000 (01:06 -0400)
committerDan Scott <dscott@laurentian.ca>
Thu, 27 Jun 2013 03:43:57 +0000 (23:43 -0400)
commit2f9c80ae6b6a3a8ed1f7d2b91f310a6faf1d69fa
tree6b974e647a24214e2aa94f41af14bd419b80fab6
parentfceea3d2e12537ccb540a2a950a5ada22f73b7bf
Reduce index bloat involving non-search_field values

Rows in metabib.title_field_entry, subject_field_entry,
series_field_entry, and author_field_entry are doubled or tripled due to
bad logic in biblio.extract_metabib_field_entry. This results in these
tables being 2 or more times their correct size.

This was introduced in 2.2.0 when the logic for browse_field and
facet_field were added to biblio.extract_metabib_field_entry. 2.1 is not
affected.

The duplicates are caused when biblio.extract_metabib_field_entry
returns TRUE in the search_field column for all rows even if they should
just be facet_field or browse_field after the first search_field value
is returned.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/030.schema.metabib.sql