During workflow execution, activity instance-related database queries are combined and sent in batches. This setup reduces the number of queries to the database and improves system performance.
Configure the buffer size
You can configure buffer parameters in the
configfile of the application or service that uses the Cora SeQuence database: Administration, Flowtime, Background Runtime Service (BRS), and Job Execution Service (JES).
|activityInstanceUpdateBufferSize||Determines the number of updated activity instances that run in a single workflow execution.|
|activityInstanceUpdateStateBufferSize||Determines the number of activity instances that have already run and require a state update, such as Status and Completion Date.|
<sequence.engine> ... <workflowExecution
Depending on how your system uses data, you need to change the default buffer parameters, or configure additional activity properties.
|If your system uses data directly from|
|There are two possible solutions to avoid this issue: |
|If an execution fails, the risk of losing data is as big as the configured buffer size.||Configure the buffer size carefully based on how your system uses data.|