Specifies how many journal pages should be written before a checkpoint is inserted.

The default value is DB_DEF_CHECKPOINT_INTERVAL.

All modifications to the database are recorded in a journal to facilitate recovery. Checkpoints are periodically inserted into the journal to improve recovery performance and allow old journal entries to be deleted. Inserting a checkpoint requires a small extra time overhead.

A high checkpoint interval will slightly increase the average speed of database operations. A low checkpoint interval will save storage space by preventing the journal from becoming excessively large. A low checkpoint interval also ensures faster recovery if the application crashes.

See also:
DB_MIN_CHECKPOINT_INTERVAL, DB_MAX_CHECKPOINT_INTERVAL, DB_DEF_CHECKPOINT_INTERVAL


Copyright © 2005-2008 ITTIA®. All rights reserved.