Use snapshot isolation for uploads.
mlsrv11 -c "connection-string" -esu ...
By default, MobiLink uses the SQL_TXN_READ_COMMITTED isolation level for uploads. In most cases, this is the optimal isolation level.
If you use snapshot isolation for uploads, you may generate conflicts on snapshot transactions during upload updates. If this happens, the MobiLink server rolls back the entire upload and retries it. In this case, you might want to adjust your settings for the MobiLink server options -r or -rd to specify the delay time between retries and the maximum number of retries.
You can change the default isolation level in a script. To change the upload isolation level, you would typically use the begin_upload script.
This option only applies to SQL Anywhere version 10 and Microsoft SQL Server 2005 consolidated databases.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|