Red Hat Bugzilla – Bug 1008333
Impact of Indices applied on JBPM tables
Last modified: 2013-10-24 00:26:29 EDT
I found deadlock issue while deleting process instance in multi-user environment.
As suggested one of the forum of RED-HAT i have created indices. here is URL of forum
After applying these indices deadlock issue resolved for me.
My questions are:
1. How much database size will increase after applying these indices?
2. What will be impact on insertion operations such as Create Process Instance and Execute Transitions operations?