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

    • Template:
    • Sprint:
      Core: F - Sprint 87, Core: F - Sprint 88
    • Development Team:
      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

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

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases