This setting determines the number of times Dexterity will retry a sanScript statement once a deadlocked condition occurs between two users or scripts. If this setting is not used, the default number of tries is 0.
SQLDeadLockRetries=option
• option - An integer corresponding to the number of retries. Values range from 0 to 1000.
A record is considered deadlocked when two users or scripts lock separate records, then also attempt to lock the record already locked by the other. Both requests are denied by the SQL database, forcing both scripts to wait until one gives up the lock. This setting determines the number of times the request for a lock will be issued when this condition occurs.
A deadlock condition will typically occur when a save statement is issued, when a change or get statement is issued with the lock parameter, or when the call sproc statement is used.