CommitTriggers parameters
The [CommitTriggers] parameters determine when the High-speed Apply Engine issues SQL COMMIT statements during an apply request.
These parameters apply only when High-speed Apply Engine distributes work between multiple agents based on tables or partitions (when the DistributionType parameter is Object). High-speed Apply Engine ignores these parameters when the DistributionType parameter is UR.
Parameter | Reference |
|---|---|
CommitOnDemand | |
StatementCount | |
Time |
The following figure shows an example of the [CommitTriggers] section.
StatementCount=1000
Time=120
The [CommitTriggers] parameters are optional. They apply to each active agent for the apply request. Depending on the apply request, a given agent might not reach the commit threshold until the end of the job.
If you specify both StatementCount and Time parameters, High-speed Apply Engine issues a COMMIT statement when either limit is reached, and resets the counters for both parameters.
Related topic