Pub date sorting/filtering causes slow OPAC search
Bug #1514549 reported by
Chris Sharp
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
OPAC searching and sorting by publication date is resulting in very slow searches. Core query SQL from an example search sorting on pub date that took 62 seconds on the database is attached. EXPLAIN ANALYZE to follow.
Evergreen 2.7.2
OpenSRF 2.4.0
PostgreSQL 9.3
Ubuntu LTS
tags: | added: opac performance search |
To post a comment you must log in.
Adding a pubdate filtering example...