ASA Database Administration Guide
Determines when the server returns control to an application following a COMMIT.
Integer, in milliseconds.
Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.
500
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.
For more information, see DELAYED_COMMITS option [database].
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.