Uploaded image for project: 'FOLIO'
  1. FOLIO
  2. FOLIO-2573

Paused due to POC of Elastic Search. All Search Options Should be Supported by a Database Index

    XMLWordPrintable

Details

    • Core: F - Sprint 87, Core: F - Sprint 88
    • Prokopovych

    Description

      In order to (hopefully) pre-empt inadequate performance when searching inventory using the defined options in the reference UI, database indexes should be created for each CQL criteria that is generated by the reference UI

      Considerations

      • Should improve the baseline performance of inventory search (to be verified during the end of quarter release process)
      • Back end work required for every new search option e.g. a new filter
      • Will need to be maintained every time the UI changes it's query generation
      • May reduce write performance (especially when upgrading the system or migrating from existing systems)
      • May not improve performance in all cases

      TestRail: Results

        Attachments

          Issue Links

            defines

            New Feature - New feature requests UXPROD-3513 Inventory Elastic Search (Morning Glory): Timebox for Priority Inventory Search and Filter Enhancements

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-790 Filter Instance records by Date updated

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

            New Feature - New feature requests UXPROD-2806 Create Elasticsearch indexes for Inventory search

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CIRCSTORE-215 Missing Indexes Warnings

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-472 Search queries without database index

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

            New Feature - New feature requests MODINVSTOR-496 cancel long running instance searches

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-499 Add Index for Instances Full-text Subjects Search

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-500 Instance source index for = search

            • 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. MODINVSTOR-510 Inventory filtering by Item status is slow (when searching item status: Available)

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-515 Holdings source index for filtering

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-530 Create a database supported search index for often used query searches

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. PERF-48 Inventory. Slow query when filtering on Item status: Available

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. PERF-76 Run performance tests following addition of Index for Instances Full-text Subjects Search

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

            New Feature - New feature requests RMB-534 Reject CQL queries that match no index in schema.json

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

            New Feature - New feature requests RMB-615 cancel queries that take longer than limit

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

            Task - A task that needs to be done. RMB-742 Create indexes on metadata.createdByUserId and metadata.updatedByUserId

            • TBD - To be determined
            • Open

            Activity

              People

                Unassigned Unassigned
                marcjohnson Marc Johnson
                Votes:
                0 Vote for this issue
                Watchers:
                22 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases