|
Temporarily sets a commit count threshold, after which a commit flush is performed.
Connections that have been configured as COMMIT_FLUSH=grouped.
| Context | Implemented by |
|---|---|
|
From the command line Use the ulinfo utility. |
Use the following utility option: -x=value |
|
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. |
Integer
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.