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

Performance issue using the getProcessInstancesByVariableNameAndValue query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.3.0.GA
    • 7.1.1.GA
    • jBPM Core
    • None
    • CR1
    • ?
    • 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.

      Attachments

        Activity

          People

            swiderski.maciej Maciej Swiderski (Inactive)
            rhn-support-mputz Martin Weiler (Inactive)
            Marian Macik Marian Macik
            Marian Macik Marian Macik
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: