Sets auto checkpoint on.
ConfigPersistent ConfigPersistent.setAutocheckpoint( boolean auto_checkpoint ) throws ULjException
auto_checkpoint true, to set autocheckpoint on.
A database has checkpoint turned on when committed change operations are applied to the persistent rows in the persistent store. When auto checkpoint is active, a checkpoint occurs as part of each commit; otherwise, a transaction record is written to record the change and the persistent row storage is not changed until the application invokes the checkpoint method.
Change and commit operations operate faster when auto checkpoint is not active but database startup can be slower if many transactions without checkpoints exist.
Autocheckpoint is always true if indexes are not persistent or if row limitation is enabled.
This ConfigPersistent with the auto checkpoint set.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |