Is anyone else having performance problems related to the deleteProcessInstance call? We are having extremely poor performance on this call. In the order of 10-15 minutes per delete.
We are running against an Oracle 9i DB. The DB has 2 CPUs dedicated to our schema and plenty of memory. Everything else is running well enough. We have tracked down the call that is taking forever. Its the 'delete from JBPM_LOG where TOKEN_=?' call. This table has 2.5 million entries in it and indexes on the ID_ and TOKEN_ columns. We add about 2000 instances per day to the system. At the current delete rate we cannot delete finalized instances nearly as fast as we put them in. Has anyone else seen this problem? Do we really need to keep these log entries around? Can we bulk delete them based on date for instance? If we do a bulk delete by date will this affect the data integrity of the other tables? Is there a way to disable creating these log entries? We are currently running JBPM 3.0.1. Any help would be appreciated. Thanks, Fallow View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3929089#3929089 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3929089 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
