Specifies the maximum delay between an application executing a COMMIT and the COMMIT actually being written to disk when the delayed_commits option is set to On.
Integer, in milliseconds
Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.
This option has meaning only when delayed_commits is set to On. it governs when a COMMIT entry in the transaction log is written to disk. With delayed_commits set to On, the database server waits for the number of milliseconds set in the delayed_commit_timeout option for other connections to fill a page of the log before writing the current page contents to disk. See delayed_commits option [database].
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|