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

Task operations are slower after a join was introduced in "getTaskInstanceById" query

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 7.5.0.GA
    • 7.4.0.GA
    • jBPM Core
    • None
    • CR2
    • CR1
    • Task operations like Start, Complete or Claim can be noticeably slower when KIE Server API or the UserTaskService is used. This known issue will be fixed in a patch release. The fix will restore the performance of these operations to the previous state.
    • 2019 Week 29-31, 2019 Week 32-34, 2019 Week 35-37

    Description

      The getTaskInstanceById query was changed in JBPM-8116. A join with another table, called NodeInstanceLog, is needed now to retrieve slaDueDate and slaCompliance information.

      The results are:

      Operation Before (without JBPM-8116) After (with JBPM-8116) Difference
      Task Start 17.0104 ms 26.7346 ms +57%
      Task Complete 39.3893 ms 49.5466 ms +26%
      Task Claim 16.2741 ms 25.9019 ms +59%

      The introduction of the join was accepted in the PR but we should probably at least include this in the release notes that we are aware of it. If it is decided that this decrease is not acceptable, we might try to implement it differently.

      Attachments

        Issue Links

          Activity

            People

              nmirasch@redhat.com Neus Miras Chueca
              mmacik@redhat.com Marian Macik
              Marian Macik Marian Macik
              Marian Macik Marian Macik
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: