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
- If an execution fails, the risk of losing data is as big as the configured buffer size.
- If your system uses data directly from
tblInstanceActivitiesdatabase table, such as stored procedure activities, set the buffer parameters to "1.