[comp.databases] Paradox 3.5 Record Size Calculation

gburlile@magnus.acs.ohio-state.edu (Greg Burlile) (06/13/91)

As a general rule you can use the following information to determine the number
of bytes per record:

 Field Type    Description       Bytes for Storage
 ==========    ===========       =================
     A         Alphanumeric      1 byte per character
     N         Numeric           8 bytes
     D         Date              4 bytes
     S         Short Number      2 bytes
     $         Currency(Numeric) 8 bytes

The above values can be used to calculate the number of bytes per record.
usually there are some sort of database "overhead" storage of about 1300 bytes.
This should help get you in the ball park for users to be able to estimate disk
storage needed.