cancel
Showing results for 
Search instead for 
Did you mean: 

Cancelling processes performance

pfeiffer
Champ in-the-making
Champ in-the-making
Hi,

I'm in a case were we need to be able to remove running process instances very quickly. I did a test with a small workflow of ours that has a super process instance, a sub process instance with two multi instance tasks in it and 2 timer events attached. Reading through the API I don't have any choice but issuing a runtimeService.deleteProcessInstance(processInstanceId, reason); and do this in a loop iterating over all parent process instances. However sometimes it seems that a delete takes even around 100 ms which is a lot in respect to what should be done.

I'm using a Oracle 10g XE edition and running it all on my local machine. The history level is that standard and only some  (+- 10) start form variables are added when starting the workflow. If I look at the command doing the delete it seems to be doing a lot of stuff. Is there any way of improving the performance or deleting multiple processinstances in batch ?

Kind Regards
1 REPLY 1

trademak
Star Contributor
Star Contributor
The delete process instances needs to cleanup quite some stuff, but 100 ms is really a lot. Can you look for queries that are slow against your Oracle database. Maybe it's a matter of adding some indexes.

Best regards,