Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-1467

no index created for AuditTaskImpl table

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.1.0.GA
    • 7.0.2.GA
    • jBPM Core
    • None
    • 2018 Week 33-35

    Description

      There's no indexes created for the AuditTaskImpl table. This results in full table scan and causes performance issues.

      Can we add additional indexes to this table?

      create index IDX_AuditTaskImpl_taskId on AuditTaskImpl(taskId);
      create index IDX_AuditTaskImpl_processInstanceId on AuditTaskImpl(processInstanceId);
      create index IDX_AuditTaskImpl_workItemId on AuditTaskImpl(workItemId);
      create index IDX_AuditTaskImpl_name on AuditTaskImpl(name);
      create index IDX_AuditTaskImpl_processId on AuditTaskImpl(processId);
      create index IDX_AuditTaskImpl_status on AuditTaskImpl(status);

      Attachments

        Issue Links

          Activity

            People

              rhn-support-tsurdilo Tihomir Surdilovic (Inactive)
              rhn-support-ghu Gary Hu
              Marian Macik Marian Macik
              Marian Macik Marian Macik
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: