Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Performance improvement tips » Use the cache to improve performance

Use the cache to improve performance Next Page

Limiting the memory used by the cache


The initial, minimum, and maximum cache sizes are all controllable from the database server command line.

You can also disable dynamic cache sizing by using the -ca 0 server option.

The following server properties return information about the database server cache:

For information about obtaining server property values, see Server-level properties.

See also