Record attribute indexing slowed by non-index configuration
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
EG 2.9+
A huge number of rows (700+) have been added to config.
One potentially easy win is to limit the group of attributes considered at ingest to only those which might index something. Quick testing indicates a substantial speed boost to typical use of metabib.
WIP Branch is here:
http://
working/
One reason the above branch makes the difference is does is greatly reducing the number of resulting selects to config.
CREATE INDEX ON config.
This change in early testing cuts processing time by an additional ~15% over the branch above. Other indexes have been tried with diminishing returns, but these are still being investigated.
In addition, we should consider whether some of the newer config rows should in fact have 'filter' turned off in stock. The 'filter' attribute is true by default in the config.
Changed in evergreen: | |
assignee: | nobody → Dan Wells (dbw2) |
Changed in evergreen: | |
assignee: | Dan Wells (dbw2) → Mike Rylander (mrylander) |
Changed in evergreen: | |
assignee: | Mike Rylander (mrylander) → nobody |
milestone: | none → 2.11-beta |
status: | Fix Committed → Fix Released |
Hi Dan,
After Dyrcona loaded this patch on his dev server, I noticed that filtering by format is no longer working. To rule out other possible causes, I installed the branch on a fresh VM and confirmed that the search filter problem occurred there as well.
Basically, if I do a search limited by one of the stock search filters, I immediately get a search results page with zero results.