Cora Knowledge Center


Configure workflow persistence


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 theconfigfile of the application or service that uses the Cora SeQuence database: Administration, Flowtime, Background Runtime Service (BRS), and Job Execution Service (JES). 


activityInstanceUpdateBufferSizeDetermines the number of updated activity instances that run in a single workflow execution.

Default: 10
activityInstanceUpdateStateBufferSizeDetermines the number of activity instances that have already run and require a state update, such as Status and Completion Date.

Default: 30

Sample code

    ...    <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 tblInstanceActivities database table, such as stored procedure activities, set the buffer parameters to "1.