Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-332

Improve performance of left-anchored SRS queries

    XMLWordPrintable

    Details

    • Template:
      Thunderjet/Firebird Back-end Story Template
    • Sprint:
      eHoldings Sprint 120
    • Story Points:
      3
    • Development Team:
      Spitfire
    • Affected Institution:
      Cornell
    • Epic Link:

      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:

      1. 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

              Activity

                People

                Assignee:
                Igor_Gorchakov Igor Gorchakov
                Reporter:
                jenncolt Jenn Colt
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases