RetryDelay


The RetryDelay parameter specifies the number of seconds that the High-speed Apply Engine waits between retry attempts for conflict resolution. High-speed Apply Engine uses this parameter only when the Code parameter of a conflict resolution rule is RIConflict (or the individual SQL codes defined by RIConflict) and the Action parameter is Retry.

Related topic

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[Conflict]

Abbreviation

None

Required?

No

Valid values

An integer from 0 to 32767, representing a number of seconds

Default value

0 (no delay)

Usage

Specify the number of seconds that you want the High-speed Apply Engine to wait between retry attempts. By default, High-speed Apply Engine does not wait (RetryDelay=0).

Use this parameter only when your apply request encounters time-dependent RI-related conflicts. This parameter changes the timing of any retry attempts for conflict resolution.

For example, assume a conflict resolution rule has a Code parameter of RIConflict. As the apply request runs, one agent attempts to insert a row in a child table before another agent has inserted the required row in the parent table. Conflict occurs. The RetryValue and RetryLimit parameters cause High-speed Apply Engine to retry the child insert action five times (in case the other agent performs the parent insert action), but the conflict is not resolved. You can increase your RetryValue and RetryLimit values, but that action increases the overhead with more retry attempts. Alternately, you can use this parameter to slow down the existing five retry attempts by waiting a given number of seconds between each attempt.

 

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