We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Configure automatic commit-and-sleep behaviour for long-running transactions
Tells the database connection to automatically commit and briefly pause after writing a given number of records. This prevents lock escalation during large batch writes. Both the sleep interval and the record frequency must be integers.
| Parameter | Description |
|---|---|
| cmd | Milliseconds to sleep |
| Argument 0 | How many records to write between sleeps |
CommitSleepMode "Milliseconds to sleep", "How many records to write between sleeps"