<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Cleaning up the JBPM internal db
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/abhishekmjboss">Abhishek Mishra</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/832701#832701">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p style="text-align: left;">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); ". </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="text-align: left;">Here I would like to know if we run this in production is there going to be any impact ? </p><p style="text-align: left;">What's extra parmeter/setting we will have to check if we go by this ? </p><p style="text-align: left;">Is there any alternative ways to get read of this and free the space ?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="text-align: left;">Could you please review this and let me know?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="text-align: left;">Thanks in advance.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="text-align: left;">Thanks,</p><p style="text-align: left;">Abhishek</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/832701#832701">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>