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

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases