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

filtering /instance-storage/instances by 'query=id=xxx' does not perform

    XMLWordPrintable

Details

    • Core: Platform

    Description

      Using CQL to filter the instances by ID results in poor performance.

      evaluk can you please provide a SQL generated in this case

      CQL query:

      /instance-storage/instances?query=id=6312d172-f0cf-40f6-b27d-9fa8feaf332f

      Resulting SQL:

      WHERE lower(f_unaccent(instance.jsonb->>'id'))
   ~ lower(f_unaccent('(^|[[:punct:]]|[[:space:]]|(?=[[:punct:]]|[[:space:]]))6312d172-f0cf-40f6-b27d-9fa8feaf332f($|[[:punct:]]|[[:space:]]|(?<=[[:punct:]]|[[:space:]]))')) 
  ORDER BY lower(f_unaccent(instance.jsonb->>'title')) LIMIT 10 OFFSET 0

      As UI inventory uses CQL queries like the below, the view cannot be simply removed in order to benefit from CQLPG-58 and instead an alternative is needed. RMB-305 might provide part of that, or this work might need something similar to the proposal in MODINVSTOR-185

      ((title="*" or contributors adj "\"name\": \"*\"" or identifiers adj "\"value\": \"*\"")) and holdingsRecords.permanentLocationId="fcd64ce1-6995-48f0-840e-89ffa2288371" sortby title

      adam heikki marcjohnson hji evaluk

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODINVSTOR-238 Performance: GET 200 - instance-storage by ID from POST above

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

            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
            relates to

            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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-248 filtering /item-storage/items when used with 'query=id=XXX' is too slow

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-255 GET 200 - instance-storage by source: query=source=abc takes 360 s

            • P4 - lowest priority level, nice-to have things that require future discussion and design
            • Closed

            Task - A task that needs to be done. MODINVSTOR-256 Improve performance of /instance-storage/instances?query=holdingsRecords.permanentLocationId=abc*

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

            New Feature - New feature requests FOLIO-1771 clean up and isolate tests

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-247 filtering /item-storage/items by 'query=barcode==123' does not perform

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed

            Activity

              People

                nassar Nassib Nassar
                jakub Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases