Uploaded image for project: 'UX Product'
  1. UX Product
  2. UXPROD-1136

General tuning of Inventory search indexes

    XMLWordPrintable

Details

    • XXL < 30 days
    • Core: Platform
    • R1
    • R1

    Description

      Review of Inventory database index configuration and appropriate tuning for the following search and sort indexes:

      1. Fulltext search for scalar fields:

      • title

      2. Fulltext search for repeatable fields

      • creators
      • subjects

      3. Identifier (exact) search fields:

      • instance ID
      • barcode (requires data join support)
      • identifiers (ISBN/ISSN)
      • language filter/facet
      • resource type filter/facet
      • location filter/facet (requires data join support)

      This item is specific to Inventory but builds on general work in Q3 and Q4, namely:

      UXPROD-1048
      UXPROD-1049
      UXPROD-1134

      This is also related to general response performance tuning in FOLIO see:

      UXPROD-752

      TestRail: Results

        Attachments

          Issue Links

            is blocked by

            Bug - A problem which impairs or prevents the functions of the product. CQLPG-58 ID searches way too slow

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Umbrella - CQLPG-59 Get rid of the regexp indexes and queries

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CQLPG-61 Equals empty is not same as equals star

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-163 queries involving contributors or subject do not use an index

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • In progress

            Umbrella - MODINVSTOR-166 Analyze and optimize search indexes

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-181 Tune primary ID indexes

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-182 analyze and optimize identifiers array indexes (ISBN, ISSN, LCCN, OCLC, …)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-184 Analyze filtering by resource type

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-185 Analyze filtering by location

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-188 Analyze and optimize filtering by language

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is cloned by

            New Feature - New feature requests UXPROD-1426 General tuning of Inventory search indexes pt2

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            New Feature - New feature requests UXPROD-1427 General tuning of Inventory search indexes pt2

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                jakub Jakub Skoczen
                jakub Jakub Skoczen
                Jakub Skoczen Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases