Consultor Eletrônico

Status: Verified

GOAL:

Summary of the Progress RDBMS limits for Version 9

GOAL:

What is the maximum number of fields in a Progress database table?

FACT(s) (Environment):

Progress 9.x

FIX:

It should be pointed out that the limits given below are theoretical.  Most of these limits cannot be supported by hardware and backup systems currently available.  However, Progress architecture improvements have effectively removed many obstacles to Very Large Database (VLDB) support.

Physical Size Limits

   Maximum Number of Storage Areas      1,000 areas
   Maximum Number of Records per Storage Area     2 Billion
   Maximum Single Table/Index                    16 TB
   Maximum Recovery Log Size                     32 TB
   Maximum Database Size                         16 TB

Progress RDBMS Size Limits

  Maximum area size                         16 TB
  Maximum extents per storage area         255
   Tables per database                   32,767
   Tables per storage area               32,767
  Records per table                          2 Billion
  Maximum Roll-Back Log Size                32 TB
   Maximum Roll-Forward Log Size             32 TB
   Indexes per database                  32,767
  Indexes per table                     32,767
  Columns per table                     32,000
   Columns (key components) per index        16
   Sequence generators per database       2,000
  Concurrent users                      10,000
  Concurrent transactions               10,000
   Minimum block size                     1,024 bytes
   Maximum block size                     8,192 bytes
  Maximum row size                      32,000 bytes
  Maximum key size                       1,000 bytes
   Maximum column width                      32 KB
   Maximum sequence value                     2^31 - 1
  Minimum sequence value                    -2^31

  Maximum number of Arguments in SQL CALL statement       50
  Maximum length of an SQL statement                  10,000 bytes
   Maximum length of a fixed-width column in a table    2,000 bytes
   Maximum length of default value specification          250 bytes
  Maximum length of a connect string                     100 bytes
  Maximum length of table name                            32 chars
   Maximum length of user-name in connect string           32 chars
   Maximum length of an error message                     256 chars
  Maximum number of columns in a table                   500
  Maximum length of a CHECK constraint clause            240 bytes
   Maximum number of nesting levels in a SQL Statement     25
   Maximum tables of table references in an SQL statement 250
  Maximum size of input parameters for an SQL statement  512 bytes
  Maximum number of outer references in an SQL statement  25
   Maximum nesting level for view references               25
   Maximum number of check constraints in a table       1,000
  Maximum number of foreign constraints in a table     1,000