Governs when a COMMIT entry in the transaction log is written to disk.
Integer, in milliseconds
Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.
This option has meaning only when cooperative_commits is set to On. The database server waits for the specified number of milliseconds for other connections to fill a page of the log before writing to disk. The default setting is 250 milliseconds.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|