Performance Issue with multi-instance task

Hi,

I am using multi-instance task. When i am completing the same seems it takes so much of time to update the database.

Please provide any input if any extra care needs to be taken when using multi-instance tasks.

Looks like it takes long time to update/delete variables table data. Around 4 to 5 mins to update an entry.

Note : Table contains around 20 million records.

Thanks & Regards,
Devakumar J

Hi Devakumar,

you have a huge table. Can you please verify that the problem only occurs if you use a multi-instance task. Maybe your database don’t work well with this amount of data. Can you analyse the database queries?

Besides that there is no special behavior for multi-instance tasks.

Please share more informations about your camunda version, database and process.

Greetings,
Philipp