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

ui-requests inefficient CQL query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: TBD
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.1.0
    • Labels:
      None
    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      Prokopovych - Sprint 113, Prokopovych - Sprint 114, Prokopovych - Sprint 115
    • Story Points:
      0.5
    • Development Team:
      Prokopovych
    • Affected Institution:
      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

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases