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

Bad query performance against ACT_HI_ACTINST with Postresql

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.7.0, 7.5.9, 7.6.5
    • None
    • None
    • None

      AT

      • given
        • engine running against PostgreSQL
        • 250000 HAI records
      • when
        • i run query against /engine-rest/engine/default/history/activity-instance
        • and sort by startTime
        • and finished=true
        • and firstResult=10
        • and maxResults=1000
      • then
        • engine performs query faster then in 1 second

      Hint
      see http://stackoverflow.com/questions/11250253/postgresql-countdistinct-very-slow
      Right now we would perform count distinct in order to perform pagination, which should work much faster in order to perform effective import into Optimize.

        This is the controller panel for Smart Panels app

            [CAM-7567] Bad query performance against ACT_HI_ACTINST with Postresql

            Michael Schoettes added a comment -

            Please adjust the fix version information

            Michael Schoettes added a comment - Please adjust the fix version information

              svetlana.dorokhova Svetlana Dorokhova
              askar.akhmerov Askar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: