Kbase P106247: How to calculate the maximum database size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/28/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