Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Connection String Parameters Reference

UltraLite CACHE_SIZE connection parameter Next Page

UltraLite COMMIT_FLUSH connection parameter

Determines when committed transactions are to be flushed to storage after a commit call. If no calls to commit are made by the UltraLite application, no flush can occur.


COMMIT_FLUSH={ immediate | grouped | on_checkpoint }

Allowed values

immediate (UltraLite default behavior)


This parameter defines which transactions are recovered following a hardware failure or crash. You may group logical auto-commit operations as a single recovery point.

By grouping these operations, you can improve UltraLite performance—but at the expense of data recoverablility. There is a slight chance that a transaction may be lost—even though it has been committed—if a hardware failure or crash occurs after a commit, but before the transaction is flushed to storage.

See also