Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-1735

Performance issue using the getProcessInstancesByVariableNameAndValue query

    Details

    • Type: Bug
    • Status: Verified (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.1.1.GA
    • Fix Version/s: 7.3.0.GA
    • Component/s: jBPM Core
    • Labels:
      None
    • Target Release:
    • Fix Build:
      CR1
    • Steps to Reproduce:
      Hide
      • Ensure that the database contains a high number of process instances and variables
      • Execute the following REST endpoint:
      /kie-server/services/rest/server/queries/processes/instances/variables/VARNAME?varValue=VARVALUE}
      
      • The attached zip file can be used for automated testing
      Show
      Ensure that the database contains a high number of process instances and variables Execute the following REST endpoint: /kie-server/services/rest/server/queries/processes/instances/variables/VARNAME?varValue=VARVALUE} The attached zip file can be used for automated testing

      Description

      The sql query used to fetch all process instances by variable name and value slows down significantly with a higher number of process instances and variables.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                swiderski.maciej Maciej Swiderski
                Reporter:
                mputz Martin Weiler
                Tester:
                Marian Macik
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: