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.

Syntax

CACHE_MAX_SIZE=number{ k | m }

Default

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

Remarks

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.

Example

The following connection string fragment sets the maximum cache size to 100 MB.

"CACHE_MAX_SIZE=100m"