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 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