topic Re: Activiti History table causing slowness in activiti process in Alfresco Archive

Activiti History table causing slowness in activiti process

anilknayak — Fri, 03 Apr 2015 14:11:26 GMT

Hi,we have been using activiti per 6 month with history enabled and we are using Oracle DB for the activiti, but recently got some performance issues.following are the observations, what I got from the performance stand point while performance test of our applicationwe have seen that the records are

Re: Activiti History table causing slowness in activiti process

jbarrez — Tue, 07 Apr 2015 13:14:13 GMT

Do you need all the historical data? You can change the history level if you don't need as much data.

In all the text above you speak about slowness and performance, but I don't see where exactly you see this happening? Process start? Task list? What is your environment?

Re: Activiti History table causing slowness in activiti process

shrey — Wed, 08 Apr 2015 15:37:52 GMT

Hi Joram,

Since we are using activti Rest API , we invoke service [ /service/task/{taskId}/complete ] to complete a user task. User task completion is followed by 1 system task(sync = on). Completion of these 2 task call consumes time.
We traced the call via dynatrace, so below query is taking around ~3 sec.
<code>
select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ?
</code>

We are not sure why ACT_HI_* tables is referred for task. This is a Activiti internal query call. I assume this might be used to update task to ACT_HI_* tables.

Regards,
Shrey Srivastava

Re: Activiti History table causing slowness in activiti process

jbarrez — Tue, 14 Apr 2015 12:01:46 GMT

Yes, it is indeed needed for updating the history data for that task.
So that being said, one option is to clean out old data, or to lower the history level. Another option might be to check why this particulary query is so slow, and add a new index to speed it up.

Re: Activiti History table causing slowness in activiti process

ivan_activiti — Thu, 25 Feb 2016 16:24:15 GMT

We ran into the same issues with using history tables. Our requirement is to store all historic processing data and make it accessible to the application. Has anyone resolved it by adding indexes?

–Ivan

Re: Activiti History table causing slowness in activiti process

jbarrez — Tue, 01 Mar 2016 20:28:44 GMT

Indices will help if you have a particular use case.
But if it's simply too much data, you'll need to solve it differently (database level, typically)

Re: Activiti History table causing slowness in activiti process

shrey — Tue, 19 Apr 2016 18:22:37 GMT

Yes we did add few indices. I can share those here asap.
Hope that it can help with Activiti release as well.

Re: Activiti History table causing slowness in activiti process

shrey — Fri, 29 Apr 2016 11:37:12 GMT

1. Add an index on ACT_HI_TASKINST(PROC_INST_ID_) —-> added as part of 5.18
2. Add an index on ACT_HI_PROCINST(SUPER_PROCESS_INSTANCE_ID_)