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
/* see sample post-install config above for more examples */
|
|
