We currently have about 35000 process instances (JBPM 3.0) in our database (Oracle 10G) and observe the tablespace growing and growing in a very fast pace. The tables that grow fastest by far are JBPM_LOG, JBPM_VARIABLEINSTANCE and JBPM_BYTEBLOCK (all 3 together need about 60% of the total tablespace). As we are not really interested in the old values of the variables and log, but still want to keep the process instance, we want to establish a database job that regularly cleans those tables. Therefore I wonder if there is a risk deleting all values from those tables that belong to a process instance that is already finished (END_ is not null). I'm pretty sure that deleting JBPM_LOG does not have any affect, but I'm not sure whether deleting values from the other tables will affect running parent-processes altough the sub process is already finished.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3913762#3913762 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913762 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
