UltraLite Database User's Guide
Connection Parameters
Additional connection parameters
Defines the size of the database cache.
| Interface | Connection parameter |
|---|---|
| Connection string | cache_size |
For information about using the connection parameter, see Specifying connection parameters.
Used when you configure a database. Use k or K, m or M to denote kilobytes or megabytes, respectively.
The minimum cache size is 4K.
The default is 16 x page_size. Actual value used is rounded down to the nearest multiple of page_size.
Defines the size of the cache. You can specify the size in units of bytes. Use the suffix k or K to indicate units of kilobytes and use the suffix M or m to indicate megabytes
The default cache size is sixteen pages. Using the default page size of 4 K, the default cache size is therefore 64 K. The minimum cache size is platform dependent.
The default cache size is conservative. If your testing shows the need for better performance, you should increase the cache size.
Increasing the cache size beyond the size of the database itself provides no performance improvement. Also, large cache sizes may interfere with the number of other applications you can use.
On the Palm Computing Platform, the parameter applies only to virtual file system (VFS) databases. The cache itself resides in record storage, not VFS storage.
For example, the following string sets the cache size to 128 K.
"cache_size=128k"