topic Cancelling processes performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cancelling-processes-performance/m-p/162509#M116386 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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&nbsp; (+- 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 ?</SPAN><BR /><BR /><SPAN>Kind Regards</SPAN></BODY></HTML> Mon, 19 Aug 2013 15:24:45 GMT pfeiffer 2013-08-19T15:24:45Z Cancelling processes performance https://connect.hyland.com/t5/alfresco-archive/cancelling-processes-performance/m-p/162509#M116386 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 ch Mon, 19 Aug 2013 15:24:45 GMT https://connect.hyland.com/t5/alfresco-archive/cancelling-processes-performance/m-p/162509#M116386 pfeiffer 2013-08-19T15:24:45Z Re: Cancelling processes performance https://connect.hyland.com/t5/alfresco-archive/cancelling-processes-performance/m-p/162510#M116387 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 21 Aug 2013 07:06:29 GMT https://connect.hyland.com/t5/alfresco-archive/cancelling-processes-performance/m-p/162510#M116387 trademak 2013-08-21T07:06:29Z