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. Note that UltraLite does not grow the cache size beyond the actual file size of the database.

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++: Connecting to an UltraLite database
• ULDatabaseManager.OpenConnection method [UltraLite C++]
• UltraLite for embedded SQL: Connect to an UltraLite database
• UltraLite for M-Business Anywhere: Connect to an UltraLite database
• DatabaseManager.openConnection method [UltraLite for M-Business Anywhere]
• UltraLite.NET: Connecting to an UltraLite database
• ULConnection.Open method [UltraLite.NET]

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

"CACHE_MAX_SIZE=100m"