Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
eHoldings Sprint 120
-
3
-
Spitfire
-
Cornell
Description
Purpose/Overview:
Right now left anchored searches are inefficient and sometimes cause time outs. This story is to improve the performance of the search.
Requirements/Scope:
- Performance improves enough to avoid timeouts on a collection of 15million bib records
Approach:
As a result of the investigation in MODSOURCE-319 it is agreed to apply indexes for the values of concrete marc fields (partitions) that are used in a search request. I created B-tree indexe on the values for 035 field and tested the query. The index makes the query to work up to 10 times better in some cases.
In this story we need to define B-tree indexs on the values of 000-999 fields.
Example:
CREATE INDEX idx_marc_indexers_035_values ON marc_indexers_035(value text_pattern_ops);
Acceptance criteria:
TestRail: Results
Attachments
Issue Links
- is blocked by
-
RANCHER-29
Setup Rancher environment for testing MODSOURCE-332
-
- Closed
-
- relates to
-
MODSOURCE-319 Spike: HTTP 408 Request Timeout when using MARC search query
-
- Closed
-
-
MODSOURCE-358
Support rancher env preparation
-
- Closed
-
-
UXPROD-3166 Kiwi | Spitfire Tech debt
-
- Closed
-
-
MODSOURCE-401 Left anchored srs api queries don't complete on kiwi bugfest
-
- Closed
-