Impact of huge data in Activiti tables

[shrey]

Will number of number of records in Activiti db(using LDAP) affect performance?
Lets say in DB -
1. there are around 3 million process instance in ACT_HI_* TABLES.
2. there are around 3000+ active process instance.

Is it going to affect performance of active/run-time processes?
I am using REST API and faced this issue irregularly.

[yvoswillens]

Hi,

could you describe the issue you face irregularly?

Regards,

Yvo

[anilknayak]

Hi am shrey's friend. working in similar issues, I have posted similar issues in the following link

http://forums.activiti.org/content/activiti-history-table-causing-slowness-activiti-process