limits.htmTEXTBlWdJNJN Database Limits

Back to index


Current OOFILE limits as of v1.2

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 (with 8 bytes per dbBlob or dbText)
Note: that some padding may be inserted to longword boundaries.

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

Back to index


^^ZjBBEdit Lite 3.5 Prefspr limits.htmtPartSIT!PartSIT!ufjButton PreferencesrdsbpdsblF@NRD  w%w%w%    w%w%w%  "a/Q#  w%w%w%+  ,  w%w%w%3  4  w%w%w%?  @  w%w%w%w   w%w%w%   w%w%w%  w%w%w%  ,  w%w%w%5 W  w%w%w%\    w%w%w%    w%w%w%   w%w%w%    w%w%w%  1  w%w%w%6  ]  w%w%w%f |  w%w%w%    w%w%w%    w%w%w%   w%w%w%    w%w%w%  1  w%w%w%5  r  w%w%w%w    w%w%w%    w%w%w%   w%w%w%  L  w%w%w%U a  w%w%w%f  q  w%w%w%v  w  w%w%w%    w%w%w%    w%w%w%    w%w%w%  ^^Z0rZstylsoup&8859222