Kbase P7160: What is the maximum number of columns per table ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2003 |
|
Status: Unverified
GOAL:
What is the maximum number of columns per table ?
GOAL:
What is the maximum number of fields per table ?
GOAL:
Summary of Progress Version 9.X RDBMS Limits
FACT(s) (Environment):
Progress 9.X
FIX:
In theory it could be 32.000, practical limit is around 500.
There is no documentation about how many fields a file can have because it depends of how they are defined, what maintenance has been done to the file, etc. New _field-map field was created in V9. This actually contains information about the logical and physical positions of the fields as well as other information needed by the client to work with the file.
Theoretically, a record should be able to be 32K long so if you have one byte fields, you should be able to have 32K fields but of course that is not what you can have because of the information stored in the _field-map field.