Try OpenEdge Now
skip to main content
Database Essentials
Administrative Planning : Database areas : Data area optimization : Choosing an appropriate block size
 
Choosing an appropriate block size
Matching the database block size to the operating system allows for a more efficient transfer of data. If you have a block size that is too small, the operating system retrieves more blocks than your request. While that transfer of additional information might be useful, if the additional information is not used by the application, then the transfer of additional information is wasted. Larger blocks are also generally better because of the way indexes behave. If each block contains more information, then you will require fewer index blocks and fewer index levels to contain the data. Index levels in a B-tree are important. If you can eliminate a level from an index, you can save one additional I/O operation per record request.