Try OpenEdge Now
skip to main content
Database Administration
Database Basics : OpenEdge RDBMS Limits : Maximum number of records per block
 

Maximum number of records per block

You can define the maximum number of records per block for each application data area. When you define an area, you can specify 1, 2, 4, 8, 16, 32, 64, 128, or 256 records per block. If you do not explicitly specify the number of records per block when you define an application data area, the default number of records per block is:
*64 if the block size is 8K
*32 for all other block sizes
You cannot change the number of records per block for the schema data storage areas. It will always remain 32 for 1K, 2K, and 4K database block sizes and 64 for an 8K database block size. The records per block are only tunable for data areas.