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

Improve performance of SQL dataset queries by removing the count query

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 7.24.0.Final
    • Component/s: KieServer
    • Labels:
      None
    • Sprint:
      2019 Week 20-22, 2019 Week 23-25
    • Story Points:
      3
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  cristiano.nicolai Cristiano Nicolai
                  Reporter:
                  davidredhat David Gutierrez
                  Tester:
                  Jan Stastny
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: