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

    • Type: Bug
    • Status: Verified (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.0.2.GA
    • Fix Version/s: 7.1.0.GA
    • Component/s: jBPM Core
    • Labels:
      None

      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);

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tsurdilovic Tihomir Surdilovic
                  Reporter:
                  ghjboss Gary Hu
                  Tester:
                  Marián Macik
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: