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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite connection parameters

UltraLite CACHE_MIN_SIZE connection parameter

Defines the minimum size of the database cache. UltraLite manages the cache size automatically, so setting this parameter should not be necessary.

CACHE_MIN_SIZE=number{ k | m }

The default cache size for devices is 256 KB. The default cache size for desktops is 512 KB.


The cache_min_size connection parameter specifies the minimum amount of memory to allocate for the file cache. By default, the size is in bytes. Use k or m to specify units of kilobytes or megabytes.

If you set the minimum cache size to be greater than the maximum cache size, UltraLite returns an error message and the connection fails.

Any leading or trailing spaces in connection parameter values are ignored. This connection parameter's value cannot include leading single quotes, leading double quotes, or semicolons.


The following connection string fragment sets the minimum cache size to 1 MB.