Kbase P7151: How to determine the maximum area size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/06/2005 |
|
Status: Unverified
GOAL:
How to determine the maximum area size
GOAL:
Summary of Progress Version 9.X RDBMS Limits
FACT(s) (Environment):
Progress 9.1X
FIX:
The maximum area size is 16 TB, however that is based upon settings that are unlikely to be used.
The maximum size for an area depends on the size of the database block, and also how many records per block that area is set to. Below is a table that will show the various maximum area sizes:
Database Blocksize: 8192
Records Per block Maximum Area Size (in GB)
1 16384
2 8192
4 4096
8 2048
16 1024
32 512
64 256
128 128
256 64
Database Blocksize: 4096
Records Per block Maximum Area Size (in GB)
1 8192
2 4096
4 2048
8 1024
16 512
32 256
64 128
128 64
256 32
Database Blocksize: 2048
Records Per block Maximum Area Size (in GB)
1&.nbsp; 4096
2 2048
4 1024
8 512
16 256
32 128
64 64
128 32
256 16
Database Blocksize: 1024
Records Per block Maximum Area Size (in GB)
1 2048
2 1024
4 512
8 256
16 128
32 64
64 32
128 16
256 8.