Right now left anchored searches are inefficient and sometimes cause time outs. This story is to improve the performance of the search.
- Performance improves enough to avoid timeouts on a collection of 15million bib records
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.
CREATE INDEX idx_marc_indexers_035_values ON marc_indexers_035(value text_pattern_ops);