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

Analyze and optimize search indexes

    XMLWordPrintable

Details

    • Core: Platform

    Description

      Go through the UI queries (on a large dataset), and see how those should be indexed and queried, and how that will affect performance.

      (Note - this will be applicable to the whole RMB thing, mod-inventory-storage is just a suitably complex module to have enough indexes to work with)

      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

            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
            duplicates

            Umbrella - FOLIO-1934 RMB 25 release (performance, refactoring)

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

            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-183 Analyze contributor/subject 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-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

            Bug - A problem which impairs or prevents the functions of the product. UIIN-481 Investigate and implement no truncation words by default

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

            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

            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

            New Feature - New feature requests MODINVSTOR-159 Full text search index for instance title

            • 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

            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

            Activity

              People

                adam Adam Dickmeiss (Inactive)
                heikki Heikki Levanto
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases