You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@syncope.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2013/11/18 13:55:22 UTC

[jira] [Created] (SYNCOPE-441) Index on Activiti table boosts overall performance

Francesco Chicchiriccò created SYNCOPE-441:
----------------------------------------------

             Summary: Index on Activiti table boosts overall performance
                 Key: SYNCOPE-441
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-441
             Project: Syncope
          Issue Type: Improvement
            Reporter: Francesco Chicchiriccò
             Fix For: 1.1.5, 1.2.0


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



--
This message was sent by Atlassian JIRA
(v6.1#6144)