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

Bad query performance against ACT_HI_ACTINST with Postresql

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.5.9, 7.6.5
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: