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

I can run fast queries against ACT_HI_ACTINST with Postresql

    Details

    • Type: Feature Request
    • 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.

        Activity

        Hide
        michael.schoettes Michael Schoettes added a comment -

        Please adjust the fix version information

        Show
        michael.schoettes Michael Schoettes added a comment - Please adjust the fix version information

          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: