Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » MobiLink - Client Administration » Introduction to SQL Anywhere Clients for MobiLink » MobiLink SQL Anywhere client extended options

 

Memory (mem) extended option

Specifies a cache size that is used by dbmlsync when building the upload.

Syntax
mem=number[ K | M ]; ...
Remarks

Specifies the size of the cache used for building the upload, in units of bytes. A larger cache means that dbmlsync can keep more pages of data in memory, thus reducing the number of disk reads/writes and improving performance.

Use the suffix k or m to specify units of kilobytes or megabytes, respectively. The default is 1M.

This option has a short form and long form: you can use mem or Memory.

You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.

See also
Example

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "mem=2M"

The following SQL statement illustrates how you can store this option in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION mem='2m';