Consultor Eletrônico



Kbase P106247: How to calculate the maximum database size
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   28/08/2008
Status: Unverified

GOAL:

How to calculate the maximum database size

GOAL:

How large can a database grow

GOAL:

What is the maximum size of a Progress database

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

FIX:

The maximum size of a Progress database is determine by two values:

The Maximum storage are size
The Maximum number of storage areas, which is 1000 where the first six are mandatory and the remaining 994 are set aside for application data and AI storage area
The formula to calculate the maximum database size is as follow:

Maximum Database Size = Maximum Storage Area Size * Maximum Number of Storage Area
For example: A database residing on a Windows system that uses 32 records per block and a 4K database block size will have 256 GB as the maximum storage area size (P106246 )

Maximum database size = 256 GB * 1,000 = 256 TB