Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-8559

Improve performance of SQL dataset queries by removing the count query

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 7.24.0.Final
    • None
    • KieServer
    • None
    • 3
    • NEW
    • NEW
    • 2019 Week 20-22, 2019 Week 23-25

    Description

      The DataSet's rowCountNonTrimmed is used for pagination purposes in order to know how many rows are available. In some cases this is not required, so we need to somehow make the count query execution optional by, for example, adding a flag in the DataSetLookup interface that customers can set.

      Attachments

        Issue Links

          causes

          Bug - A problem that impairs or prevents the functions of the product. JBPM-8667 Disable SQLDataSet size estimation breaks DB2 on JWS

          • Critical - To be worked on immediately following BLOCKER issues.
          • Resolved
          is related to

          Bug - A problem that impairs or prevents the functions of the product. RHPAM-1630 Long execution time of the query jbpmHumanTaskWithVariables causes PAM to timeout

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed
          relates to

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) RHPAM-2169 Improve performance of SQL dataset queries by removing the count query

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              cnicolai@redhat.com Cristiano Nicolai
              david.magallanes David Gutierrez
              Jan Stastny Jan Stastny
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: