AnsweredAssumed Answered

parent_task_id_ in ACT_RU_TASK degrading performance

Question asked by cduvvuri on Oct 9, 2014
Latest reply on May 28, 2015 by trademak
We are using activiti 5.9
In our case we do not have scenario of populating parent_task_id_ column in ACT_RU_TASK. After having considerable volume in the activiti tables.

For any new signal/workflow change following query is fired before completing the task.

select * from ACT_RU_TASK where PARENT_TASK_ID_ = ?

As this column is null in all the records, query is taking unusally huge time doing full table scan.

In ACT_RU_TASK we have 1375k records with PARENT_TASK_ID_ as null.

On an avg. query is taking 4s

Outcomes