Rows doubled or tripled in metabib.%_field_entry tables
Bug #1032208 reported by
Bob Wicksall
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
2.3 |
Fix Released
|
Medium
|
Unassigned | ||
2.4 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Evergreen 2.2.0
Rows in metabib.
This was introduced in 2.2.0 when the logic for browse_field and facet_field were added to biblio.
The duplicates are caused when biblio.
Changed in evergreen: | |
assignee: | nobody → Mike Rylander (mrylander) |
Changed in evergreen: | |
milestone: | none → 2.4.0-alpha |
Changed in evergreen: | |
status: | New → Confirmed |
Changed in evergreen: | |
milestone: | 2.4.0-alpha1 → 2.4.0-beta |
Changed in evergreen: | |
milestone: | 2.4.0-beta → 2.4.0-rc |
importance: | Undecided → Medium |
Changed in evergreen: | |
milestone: | 2.4.0-rc → none |
no longer affects: | evergreen/2.2 |
Changed in evergreen: | |
status: | Confirmed → Fix Released |
To post a comment you must log in.
I'm attaching a modified biblio. extract_ metabib_ field_entry that should resolve this issue. On our test server this has had a fairly significant impact on row counts and table sizes:
author_ field_entry 1786920 rows before and 494144 rows after field_entry 330018 rows before and 108101 rows after field_entry 4506630 rows before and 971917 rows after
series_
subject_
title_field_entry 1032180 rows before and 528558 rows after
I'm not sure if this translates to faster searches but it "feels" faster to me.