[SYNCOPE-441] Index on Activiti table boosts overall performance

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.5, 1.2.0-M1
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 18/Nov/13 12:54
• Updated: 28/Nov/13 07:55
• Resolved: 19/Nov/13 10:03

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