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.

Related topic

BindTuning-parameters

Parameter

Reference

CommitOnDemand

StatementCount

Time

The following figure shows an example of the [CommitTriggers] section.

[CommitTriggers]
  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.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*