Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-182

analyze and optimize identifiers array indexes (ISBN, ISSN, LCCN, OCLC, …)

    XMLWordPrintable

Details

    • Core: Platform

    Description

      Identifiers are kept in an array, each element having an identifier type id (UUID that points to an identifierType that has a name like 'ISBN'), and a value.

      Acceptance criteria:

      • provide schema.json entries that should be used for creating applicable indexes for identifier type fields
      • PG query explain should clearly show index in use
      • perform performance testing for CQL queries 
        • (identifiers adj "\"value\": \"40*\"") sortby title
        • identifiers == "*\"value\": \"40*\", \"identifierTypeId\": \"8261054f-be78-422d-bd51-4ed9f33c3422\"*" sortby title

      TestRail: Results

        Attachments

          Issue Links

            blocks

            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

            Umbrella - MODINVSTOR-166 Analyze and optimize search indexes

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

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

            • 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
            is blocked by

            Task - A task that needs to be done. FOLIO-1757 Add a test case for instance identifier search

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

            New Feature - New feature requests FOLIO-1771 clean up and isolate tests

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

            New Feature - New feature requests CQLPG-42 Array searches in the FT mode

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

            Sub-task - The sub-task of the issue FOLIO-922 Searching in repeated fields (arrays) in PostgreSQL JSON records.

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

            Task - A task that needs to be done. MODINVSTOR-215 use sort or search index depending on the result size

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-266 Fix identifier search slowness due to mismatch between index and query

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

            Task - A task that needs to be done. RMB-380 implement new approach for searching array-of-strings and array-of-objects fields

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

            New Feature - New feature requests CQLPG-81 Redesign CQL to SQL generation

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

            Activity

              People

                adam Adam Dickmeiss
                heikki Heikki Levanto
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases