Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-8485

Historic activity statistics query takes too long for large datasets

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      • there is a lot of entries in historic activity database table
      • request Historic activity statistics by calling {{GET /history/process-definition/ {id}

        /statistics}}

      Actual result

      • it takes too long the query to be completed, sometimes the timeout happens

      Expected result

      • statistics is returned in reasonable amount of time, no matter how large the database is

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            is depended on by

            Bug Report - A problem which impairs or prevents the functions of the product. CAM-8661 In Cockpit, I cannot restrict heatmap/statistics by time period in case of large datasets

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Task - A task that needs to be done. CAM-8284 Analyse performance of historic activity statistics query for MariaDB

            • L3 - Default - Minor issue or issue with existing workaround, feature requests and questions
            • Closed

            Activity

              People

                yana.vasileva Yana Vasileva
                meyer Daniel Meyer
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce