OPAC searching significantly slowed by adding format filters
Bug #1438136 reported by
Chris Sharp
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
High
|
Unassigned | ||
2.7 |
Fix Released
|
High
|
Unassigned | ||
2.8 |
Fix Released
|
High
|
Unassigned |
Bug Description
We have discovered that adding a format filter to OPAC search causes a significant delay. Example from PINES:
Keyword search for the term "lusitania" scoped to the Leesburg Library returns results within a few seconds:
http://
However, if you add a format filter by selecting "All Books" from the "Limit to:" dropdown menu, the search takes far longer (nearly 30 seconds):
Evergreen 2.7.2
OpenSRF 2.4
PostgreSQL 9.3
Ubuntu LTS
Changed in evergreen: | |
milestone: | none → 2.8.1 |
milestone: | 2.8.1 → none |
importance: | Undecided → High |
Changed in evergreen: | |
status: | New → Triaged |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Chris,
An explain-analyze of the core query would be really good to have. I suspect bad stats on the attribute vector list table, but there's no way to tell without more info.