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

GET 200 - instance-storage by source: query=source=abc takes 360 s

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 64
    • Story Points:
      2
    • Development Team:
      Core: Platform

      Description

      The performance test https://github.com/folio-org/folio-perf-test/blob/ad414b0/Folio-Test-Plans/mod-inventory-storage/instance-storage/instance-storageTestPlan.jmx#L290
      running /instance-storage/instances?query=source=abc takes 360 seconds on average.

      There is no index for the source field resulting in a full table scan.
      Other fields like title have a full text index and are fast (?query=title=abc).

      Solution:

      • If there a possibility in the front-end to run such a query? If not I suggest to change the performance test to query the title instead of the source field. And to close this issue as won't do.
      • Otherwise: add fulltextext index for the source field

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                julianladisch Julian Ladisch
                Reporter:
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases