Data Buffer

 

he data buffer stores the most recently used data blocks as pages in memory. DBMaker uses the most recently used algorithm to determine which data pages to keep in the buffer. The data buffer can be manually set to a specific value or DBMaker can automatically configure it. To have DBMaker set the number of page buffers, select Configure the buffer automatically . The Size of Data Buffer (pages) setting can be altered by inputting a value in the field or by using the up and down arrows to the right of the field. Increasing or decreasing the number of data pages in the data buffer has a dramatic effect on database performance. Refer to the section "Tuning Page Buffer Cache" in Chapter 17 of the Database Administrator's Guide for more in-depth information on optimizing this value. This setting corresponds to the DB_NBufs keyword in the dmconfig.ini file. The default value is Configure the buffer automatically .


Related topic:

Cache and Control