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

UltraLite commit_flush_count option [temporary] Next Page

UltraLite commit_flush_timeout option [temporary]

Temporarily sets a time interval threshold, after which a grouped commit flush is performed.

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_timeout=value

From a client application    Use the set database option method.

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

Allowed values

Integer, in milliseconds


10 000 milliseconds (or ten seconds)


Use 0 to disable the time threshold.

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 you have set the COMMIT_FLUSH connection parameter to 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