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 may 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.

• UltraLite CACHE_MIN_SIZE connection parameter
• UltraLite CACHE_SIZE connection parameter
• UltraLite cache_allocation option
• UltraLite connection strings and parameters
• UltraLite page_size creation parameter
• UltraLite RESERVE_SIZE connection parameter
• UltraLite for C/C++: UltraLite database connections
• ULDatabaseManager.OpenConnection method [UltraLite C++]
• UltraLite for embedded SQL: UltraLite database connection using embedded SQL
• UltraLite.NET: Connection setup for an UltraLite database
• ULConnection.Open method [UltraLite.NET]
• Cache size adjustment for an UltraLite database

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

"CACHE_MAX_SIZE=100m"