topic Re: Activiti is slowing down -- Complete task is taking time in Alfresco Archive

Activiti is slowing down -- Complete task is taking time

anilknayak — Mon, 06 Jun 2016 21:43:55 GMT

Hi,we have been using activiti 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 growing in

Re: Activiti is slowing down -- Complete task is taking time

Anonymous — Mon, 06 Jun 2016 23:54:52 GMT

You should identify the slow SQL.

If you use Oracle DB, you can identify the slow SQL from Oracle Statspack report or AWR report.

Re: Activiti is slowing down -- Complete task is taking time

anilknayak — Mon, 06 Jun 2016 23:57:23 GMT

Yes we have found out the queries and those queries are having the tables mentioned above.

Re: Activiti is slowing down -- Complete task is taking time

Anonymous — Tue, 07 Jun 2016 00:21:56 GMT

Can you tell not only table name but the slow query and it's execution plan ?

Re: Activiti is slowing down -- Complete task is taking time

martin_grofcik — Tue, 07 Jun 2016 08:25:39 GMT

Hi Anil,

I had similar issue with another BPM platform. And (after the long time of strugling with DB +++….) the conclusion was to periodically archive history. (In that case clean up the history tables and move content to the archive - does not matter how it is implemented).

Short-distance runner cannot carry whole house as a snail.

Regards
Martin

Re: Activiti is slowing down -- Complete task is taking time

Anonymous — Wed, 08 Jun 2016 12:27:37 GMT

Please tell me not only table name but the slow query and it's execution plan.