Try OpenEdge Now
skip to main content
Database Essentials
Administrative Planning : Data layout : Calculating database storage requirements

Calculating database storage requirements

The OpenEdge database engine stores all database fields and indexes in variable-length format and does not store trailing blanks in character fields or leading zeros in numeric fields. The benefits of this variable-length storage technique are:
*Disk storage is reduced.
*An application is easier to change since you can increase the maximum storage space for a field without copying or restructuring the entire database. You can put more characters into newly created records without affecting existing records.
* Formulas for calculating field storage
* Sample to estimate storage requirements
* Database-related size criteria