Performance - Bulk deletion of variables

[samson]

Hello,

I'm looking for a solution to delete variables in a bulk job.
Activiti deletes at the end of a process every variable in a single delete Statement.
In my case the deletion of 15 variables per process instance takes 17% of the whole db machine time.

If I delete it manual (ProcessEndListener)
delete from act_ru_variables where _proc_inst = ?
i've got a OptimisticLockException.

Thanks

[martin_grofcik]

Hi,

May be you are getting OptimisticLockingException because RemoveExecutionVariablesCmd (Task)  tries to delete the variables too.
I am not sure.

What I would propose is to change implementation and create pull request.

Regards
Martin

[samson]

Hi Martin,

you are right, Activiti tries to delete the variable too. That would be fabulous if someone could change the implementation.

[samson]

Jira Ticket created: http://jira.codehaus.org/browse/ACT-2037