Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-441

Index on Activiti table boosts overall performance

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1.5, 1.2.0-M1
    • Component/s: None
    • Labels:
      None

      Description

      As reported in mailing list [1], creating an index on ACT_RU_TASKS may improve significantly the overall system performance:

      CREATE INDEX RU_TEST ON ACT_RU_TASK (PARENT_TASK_ID_)

      The idea is to add such index to [2] in order to create it by default in every deployment.

      [1] http://markmail.org/message/qvriwnmaudm2vn27
      [2] https://svn.apache.org/repos/asf/syncope/branches/1_1_X/core/src/main/resources/indexes.xml

        Attachments

          Activity

            People

            • Assignee:
              ilgrosso Francesco Chicchiriccò
              Reporter:
              ilgrosso Francesco Chicchiriccò
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: