Cora Knowledge Center

Support

Configure workflow persistence

Overview

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

Parameters

ParameterDescription
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

<sequence.engine>
    ...    <workflowExecution
            activityInstanceUpdateBufferSize="10" 
            activityInstanceUpdateStateBufferSize="30"    
/>

Risks

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