Defines the size of the database cache.

Syntax

CACHE_SIZE=number{ k | m | g }

Default

The default cache size is determined by the amount of memory available on your system and the size of the database.

Remarks

If the cache size is not specified, or if you set the size to 0, the default size is used. If your testing shows the need for better performance, you should increase the cache size.

By default, the size is in bytes. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes, respectively.

If you exceed the maximum cache size, it is automatically replaced with your platform's upper cache size limit. Increasing the cache size beyond the size of the database does not provide any performance improvement, and a large cache size can interfere with the number of other applications you can use.

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

See also

• Platform specific optimization strategies for UltraLite
• Opening UltraLite connections with connection strings
• UltraLite page_size creation parameter
• UltraLite RESERVE_SIZE connection parameter
• UltraLite for C/C++: Connecting to a database
• UltraLite for C/C++: OpenConnection function
• UltraLite for embedded SQL: Connecting to a database
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for M-Business Anywhere: openConnection method
• UltraLite.NET: Connecting to a database
• UltraLite.NET: Open method

Example

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

"CACHE_SIZE=2m"