[jboss-user] [JBoss jBPM] - Performance slowdown with large JBPM_LOG table

michaelholtzman do-not-reply at jboss.com
Thu Feb 26 16:46:04 EST 2009

Greetings. We are seeing a huge  slowdown in jBPM throughput when the JBPM_LOG file gets very large.

For example, during our benchmark testing we start with a "virgin" database. After three weeks of testing, we see a ~40% increase in workflow execution time. At this point, the JBPM_LOG table has about 6M (yes, million) records.

If we clean the database tables, performance returns to its original level. I don't really understand why the size of JBPM_LOG has such a profound effect on performance.

In production we need the log records to construct an audit trail, so disabling logging is not an option. 

Any suggestions on improving performance with large JBPM tables?

Anyone running a high volume jBPM application care to comment on performance over time?

BTW, this is jBPM 3.1.2 with selected fixes from later versions applied.


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213536#4213536

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213536

More information about the jboss-user mailing list