Dbase Limits

Current OOFILE limits as of v1.4

Note: most of these are c-tree limits. Future OOFILE versions are likely to work around some of them.

Total size of fields in a dbTable:

64kb fixed-length fields (with 8 bytes per dbBlob or dbText, pointing to separate variable length records)
Note: that some padding may be inserted to longword boundaries.

Remember you can link tables with 1:1 relationships so this limit is only a minor inconvenience.

Minimum size of dbTable record:

5 bytes

Size of dbBlob field (includes dbText):

2Gb (slightly less for file overhead)

Minimum size of dbBlob

0 bytes data storage
8 bytes in the main record

Size of container file:

2Gb
Note: this may be a single database "superfile" or limit individual files
and indexes, which would be far larger than in a superfile.

Total number of tables & indices effectively limited by memory
(set by the ctMAXFIL and MAX_DAT_KEY parameters in ctoptn.h)

Indices per table:

32 (c-tree default set by ctMAX_DAT_KEY in ctoptn.h)

Size of key:

200 bytes