Performance when too many active tasks running

hongguoan — Mon, 11 Jan 2016 19:45:38 GMT

Hi:We have performance issue after activiti deployed 3 months.We found out 43% of oracle CPU time is spending on table scan on select * from ACT_RU_TASK where PARENT_TASK_ID_ = :1SQL> select count(*) from ACTIVITI_ADM.ACT_RU_TASK; COUNT(*)———- 185276 SQL> select last_analyzed from dba_tab

Re: Performance when too many active tasks running

jbarrez — Wed, 20 Jan 2016 21:26:29 GMT

I don't think 185276 rows should be a problem for modern databases.
Do you know which API/query call executes this SQL? I can see it might be executed when deleting a task (for cleaning up via parent).

topic Re: Performance when too many active tasks running in Alfresco Archive

Performance when too many active tasks running

Re: Performance when too many active tasks running