Adaptive Server supports a wide variety of database and cache configurations for all database types using named caches and database bindings. Consider the following when sizing or binding a cache:
Bind large, disk-resident databases to smaller named caches. This is a standard Adaptive Server configuration, with only a small portion of the database’s contents in cache. Depending on the workload, much of the database page space may get recycled due to normal cache replacement policies.
Make the cache size similar to the database size, which may reduce the recycling of cached pages. However, depending on the workload, writes to disk may be high.
Bind entire temporary databases to a named cache that is large enough to host the entire temporary database. Default optimizations the server applies to temporary databases (and using strategies such as delayed commit) allow you to significantly improve the performance of fully cached temporary databases.
