working with a high number of process instances

[jcosano]

I'll try to model a process that every day creates aprox. 45000 new process instances.
Now I'm preparing environment, using MySql, but the target is migrate to Oracle, with RC1

Activiti can work with this? or maybe is too much? performance will be affected with this high number of process instances?

I think that this process should be a great test for RC1


happy weekend!

[jbarrez]

Ive tested Activiti up to a million process instances.

Besides some indices that clearly needed to be added, all worked fine.
The bottleneck will definitely be your database throughput, Activiti itself has a very low overhead.

[jcosano]

Thanks!, In next weeks I can give my own experience about this situation..

[iravanchi]

@joram Which RDBMS were you using? H2 or MySQL?

[jbarrez]

MySQL through Spring.