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

Add missing indexes on VariableInstanceLog and NodeInstanceLog tables

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 6.3.0.GA
    • jBPM Core
    • None

      The audit tables VariableInstanceLog and NodeInstanceLog does not have indexes.

      Tests using databases with a big amount of data shows that indexes on these tables can considerably increase performance and reduce query execution time.

      The indexes should be added to the DDL scripts.

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-wsiqueir William Siqueira
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: