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_MAX_SIZE connection parameter

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

CACHE_MAX_SIZE=number{ k | m }

The default maximum cache size is 20 MB for devices and 50 MB for desktops.


The cache_max_size connection parameter specifies the maximum 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 exceed the maximum cache size, your platform's upper cache size limit is used instead. UltraLite does not grow the cache size beyond the actual file size of the database.

If you specify a cache size limit that is greater than the size of your database, the excess space might be used for caching rows.

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 maximum cache size to 100 MB.