[jboss-user] [jBPM] - Cleaning up the JBPM internal db

[Abhishek Mishra]

Abhishek Mishra [https://community.jboss.org/people/abhishekmjboss] created the discussion

"Cleaning up the JBPM internal db"

To view the discussion, visit: https://community.jboss.org/message/832701#832701

--------------------------------------------------------------
All - We are seeing some performance degradation in our current set up. We are using JBPM 3 with JBOSS ESB. We had a process which was earlier taking around 40 mins to complete but now that is taking hours to complete. So after doing some research we found that the internal db has grown relatively big. And this table space is occupying arround 80% of the total space. After doing some analysis we found the process deletion api from the REDHAT. Here basically we are doing "jbpmContext.getGraphSession().deleteProcessInstance(processInstance); ". 

Here I would like to know if we run this in production is there going to be any impact ? 
What's extra parmeter/setting we will have to check if we go by this ? 
Is there any alternative ways to get read of this and free the space ?

Could you please review this and let me know?

Thanks in advance.

Thanks,
Abhishek
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/832701#832701]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130814/bd082f33/attachment.html