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

Add table index

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • None
    • engine

      This query:

      processInstances = historyService
      .createHistoricProcessInstanceQuery()
      .finishedBefore(minDate.getTime())
      .processDefinitionKey(processDefinitionKey)
      .orderByProcessInstanceEndTime().asc().list();

      Leads to this SQL command:

      select RES.*
      from ACT_HI_PROCINST RES
      inner join ACT_RE_PROCDEF DEF on RES.PROC_DEF_ID_ = DEF.ID_
      WHERE DEF.KEY_ = 'ADefKey'
      and RES.END_TIME_ <= '2014-06-06 12:12:12'
      and RES.END_TIME_ is not NULL
      order by END_TIME_ asc
      LIMIT 2147483647 OFFSET 0;

      When a high load is present, this can lead to long waiting times (with over 80,000 entries -> 500-700 seconds).

      This can be reduced to <1 second with this index:

      create index PROC_DEF_ID_END_TIME ON ACT_HI_PROCINST (PROC_DEF_ID_,END_TIME_);

        This is the controller panel for Smart Panels app

            [CAM-2579] Add table index

            Matthijs created issue -
            Matthijs made changes -
            Summary Original: Add index for MySQL New: Add table index
            Matthijs made changes -
            Link New: This issue is related to SUPPORT-1184 [ SUPPORT-1184 ]
            Robert Gimbel made changes -
            Labels New: AD
            Robert Gimbel made changes -
            Labels Original: AD New: AD SUPPORT
            Robert Gimbel made changes -
            Fix Version/s Original: 7.2.0 [ 12997 ]
            Michael Schoettes made changes -
            Resolution New: Won't Fix [ 2 ]
            Status Original: Open [ 1 ] New: Closed [ 6 ]
            Thorben Lindhauer made changes -
            Workflow Original: camunda BPM [ 27479 ] New: Backup_camunda BPM [ 58946 ]

              Unassigned Unassigned
              matthijs.burke Matthijs
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: