ASE : Configuring the cache

Important: for ASE 12.5, the default data cache MUST be configured !

use master
go
sp_cacheconfig 'cache01','4M'
go


Entry in config file looks like this:

[Named Cache:dev_cache1]
cache size = 4M
cache status = mixed cache


Next, database objects need to be bound to the cache

use dev_main_db
go
sp_bindcache 'dev_cache01','dev_main_db','customer'
go
sp_helpcache
go