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)
