Documentation

Database Administrator's Guide

Previous Topic

Next Topic

COMMIT_DELAY

COMMIT_DELAY <milliseconds | -1>

Controls the length of time in milliseconds after a given transaction completes that the transaction manager waits before flushing the transaction to disk. By waiting, more than one transaction (i.e., the first one and all others that complete before the delay period expires) may be committed at the same time reducing disk-access overhead. On average, the longer the delay, the larger the number of transactions committed.

Note: Keep this delay in mind when setting a time limit for aborting transactions.

Default:

Windows 2 ms.

Unix/Linux - This value defaults to 1 ms for best performance.

See Also

TOCIndex