What does the parameter CACHE_SIZE mean?
The database parameter CACHE_SIZE specifies the size of the bugger for I/O operations used by the data cache and the converter. This parameter is very important for the performance of the database. The lower and upper limits are: 800 <= CACHE_SIZE <= 2147483640 pages. The default size of a database page is 8 KB. The converter assigns logical page numbers to physical block addresses on the data volumes. Because it is so important for database operation, the converter resides completely in main memory. The rest of the main memory (as configured by CACHE_SIZE) is used by the data cache. See also MaxDB Glossary : I/O Buffer Cache Use the monitoring functions of the Database Manager to obtain information about the data cache hit rate and the performance of the system.
