Documentation

Database Administrator's Guide

Previous Topic

Next Topic

CHECKPOINT_INTERVAL

CHECKPOINT_INTERVAL <interval in bytes or MB>

This keyword can speed up recovery at the expense of performance during updates. The interval between checkpoints is measured in bytes of log entries. It is ordinarily about one-third (1/3) the size of one of the active log files (L000....FCS). Reducing the interval speeds automatic recovery at the expense of performance during updates. The entry is interpreted as bytes if greater than 100 or as megabytes if less than 100. For example, CHECKPOINT_INTERVAL 2 sets an approximate 2MB interval, while CHECKPOINT_INTERVAL 150000 causes checkpoints about every 150,000 bytes of log file.

Default: 10 MB

See Also

CHECKPOINT_FLUSH

TOCIndex