Previous Topic: How Many Pages Should a Buffer Contain?Next Topic: Choosing a Method for Storage Acquisition


How Large Should a Buffer Page Be?

Pages as Large as Largest Database Page

The page size for a buffer must be able to hold the largest database page that will be read into that buffer. Therefore, to conserve system resources, try to assign files to the buffer with roughly equivalent block sizes (a block equals a database page).