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 Database Settings Reference » Configurable options in UltraLite

Configurable options in UltraLite Next Page

UltraLite commit_flush_count option [temporary]

Temporarily sets a commit count threshold, after which a commit flush is performed.

Applies to

Connections that have been configured as COMMIT_FLUSH=grouped.

How to set it
ContextImplemented by

From the command line    Use the ulinfo utility.

Use the following utility option:


With SQL    Use the SET OPTION statement.

Use the following statement syntax:

SET OPTION commit_flush_count=value

From a client application    Use the set database option method.

The method of setting this threshold value varies according to the programming interface you are using.

Allowed values



Use 0 to disable the transaction count. This means there is no limit on the number of commits with respects to when a flush is triggered.

This option only lasts until the named database stops running. You must set this option each time you start database, if it is required.

If you set this option in addition to the commit_flush_timeout option and if your connection parameter includes COMMIT_FLUSH=grouped, either threshold triggers a flush. When the flush occurs, UltraLite sets the counter and the timer back to 0. Then both the counter and timer are monitored, until one of these thresholds is subsequently reached.

See also