[jboss-user] [jBPM] - [Best practices] Number of the database required

wqe wqe do-not-reply at jboss.com
Mon Aug 27 06:54:47 EDT 2012

wqe wqe [https://community.jboss.org/people/drupalspring] created the discussion

"[Best practices] Number of the database required"

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

I have read the the forum that it is suggested to  separate the  Human Tasks Tables  and the JBPM5 tables in different databases. Together with the  http://docs.jboss.org/jbpm/v5.3/userguide/ch.core-persistence.html#d0e3800 documentation section 8.3 , it said :

  Storing history information in the runtime database can result in the database rapidly increasing in size, not to mention the fact that monitoring and analysis queries might influence the performance of your runtime engine. This is why process execution history information and runtime state should be stored separately.

So , I want to ask inbest practice , we should   use 3 databases for the JBPM5 project ???

* A database  for storing runtime data which has the following tables only  : eventtypes , processinstanceinfo , sessioninfo , workiteminfo
* A database for storing history information  (BAM purpose) which has the following tables only : nodeinstancelog, processinstancelog , processinstancelog
* A database for the human task

Reply to this message by going to Community

Start a new discussion in jBPM at Community

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

More information about the jboss-user mailing list