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

• -urc option
• Performance tips

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';