Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4024

BPM Suite 6 - Database Queries Performing Poorly (Adding INDEXES)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.4.0
    • 6.3.0, 6.1.0.GA
    • Business Central, Installer
    • None

    • Red Hat BPM Suite 6.x DDLs - Supplementary Tools

    • ER2
    • Hide

      The workaround is to create the indexes for those audit tables while it is not available in DDLs.

      Show
      The workaround is to create the indexes for those audit tables while it is not available in DDLs.

      Some BPM Suite 6 database queries were performing poorly (slowness) and it has been improved after adding some indexes for NodeInstanceLog and VariableInstanceLog. For instance:

      VariableInstanceLog ADD INDEX (variableId, processInstanceId);
      VariableInstanceLog ADD INDEX (variableId, value);

      And:

      NodeInstanceLog(processInstanceId,nodeType);

      The DDL scripts only create indexes for ProcessInstanceLog table. It is needed to include those indexes for the other audit tables.

              marco.rietveld Marco Rietveld (Inactive)
              rhn-support-ajuricic Amana Juricic
              Ivo Bek Ivo Bek
              Ivo Bek Ivo Bek
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: