Consultor Eletrônico

Status: Verified

GOAL:

What is the maximum number of records in a Version 6 database?

GOAL:

What is the maximum number of records in a Version 7 database?

GOAL:

What is the maximum number of records in a Version 8 database?

GOAL:

Is there a limit to the number of records I can have in a table?

GOAL:

What is the limit for records per table?

FACT(s) (Environment):

All Supported Operating Systems
Progress 6.x
Progress 7.x
Progress 8.x

FIX:

2 Billion records is the maximum number of records possible prior to version 9.
Prior to version 8 a single database block may hold as many as 32 records.
Beginning in version 8.2 a single database block may hold as many as 32 or 64 records.

Beginning in version 8.2:
For databases with a blocksize of 1k, 2k, or 4k the maximum theoretical limit for number of records in the block is 32 records. (size of the record may reduce the actual limit of records that fit in the block to less than 32)
For databases with an 8k blocksize the maximum theoretical limit for number of records in the block is 64 records. (size of the record may reduce the actual limit of records that fit in the block to less than 64)

As an Example, if the number of records per block (RPB) is 32 this implicitly limits the maximum data extent cumulative size to:
2147483648 / 32 = 67108864 bytes or 64 Gig.

As an Example, if the number of records per block (RPB) is 128 this implicitly limits the maximum data extent cumulative size to:
2147483648 / 64 = 33554432 bytes or 32 Gig.

If the database is composed entirely of 1 table (which isn't really ever the case because the database meta-schema contains hidden tables with records) then the limit of records for that table would be 2 billion minus the number of records for the meta-schema tables (that number varies depending on version of Progress and the user defined tables, fields and indices).