Uploaded image for project: 'ui-requests'
  1. ui-requests
  2. UIREQ-602

ui-requests inefficient CQL query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • TBD
    • Resolution: Done
    • None
    • 5.1.0
    • None
    • Prokopovych - Sprint 113, Prokopovych - Sprint 114, Prokopovych - Sprint 115
    • 0.5
    • Prokopovych
    • University of Chicago

    Description

      Overview:

      When creating a FOLIO request, ui-requests makes the following request when you enter the item barcode:

      /inventory/items?query=%28barcode%3D%22110485261%22%29

      (note the single %3D instead of double)

      After entering the user barcode, the same request (with the single %3D) is issued two more times. If you leave the "New request" dialog open, it appears that the app then periodically polls with that request, so it can be issued a large number of times.

      This CQL query can cause a high CPU load on the database in an environment with a large item data set. It likely should be replaced with a query using ==, and perhaps the polling behavior should be examined.

      This behavior was observed on both Honeysuckle and on the latest ui-requests (folio-snapshot).

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                zburke Zak_Burke
                wayne Wayne Schneider
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases