Hi Team,
I enabled the DEBUG/TRACE level logs today in Activiti Engine, to track the high latency in the queries for signalling task completion.
What I saw was a pile of records being fetched against statement "ExecutionEntity.selectExecutionsByParentExecutionId". This is querying the db to get all the executions for given parent_id. Plus, there are other few queries getting fired as well.
I am wondering if there is a way to cache the data somehow, to not load this every time from DB. Apparently most of the execution data is dynamic, that is difficult to manage in cache, but is there a way to reduce the number of these db calls?
I have implemented caching at my end, for most of the db calls that my system was making. Yet there are huge db calls being made by Activiti to complete the task.
I have seen in user guide the deployment cache, but couldn't find anything on this side.
Please suggest, if this is possible.
Regards
Abhishek
