Consultor Eletrônico

Status: Unverified

GOAL:

What is the recommended number of records per block when creating a database.

FIX:

There is no general number that can be given.
The number of records you want to specify per block depends on what size you want your database to be, and how much space you can use on your OS, e.g. the maximum application data storage area size is determined by database block size and records per block. (See the System Administration Guide and Reference).
Since the records-per-block definition has a basic influence on the performance the documentation should be reviewed before.

See this Peg-calculation program available at: http://www.peg.com/utilities.html