Bug 1008333 - Impact of Indices applied on JBPM tables
Summary: Impact of Indices applied on JBPM tables
Keywords:
Status: NEW
Alias: None
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: JBPM - within SOA
Version: unspecified
Hardware: All
OS: Linux
unspecified
high
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-16 07:55 UTC by jadhavpprasad
Modified: 2020-04-27 01:33 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Task

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description jadhavpprasad 2013-09-16 07:55:42 UTC 
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
https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_SOA_Platform/4.2/html/4.2.CP04_Release_Notes/sect-manually_create_jBPM_indexes_when_upgrading.html

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?
Note You need to log in before you can comment on or make changes to this bug.