Defines the size of the database cache.
CACHE_SIZE=number{ k | m | g }
The default cache size is determined by the amount of memory available on your system and the size of the database.
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.
The following connection string fragment sets the cache size to 2 MB.
"CACHE_SIZE=2m" |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |