File and Engine Specifications

<< Click to Display Table of Contents >>

Navigation:  Apollo API (Apollo Engine) >

File and Engine Specifications

Database

Max records per table 1 billion (1)

Max characters per record 64k

Max fields per record 1022

Max tables open all tasks 250 (2)

Index Files

Max characters per key (NTX) 338

Max characters per key (CDX/IDX/NSX) 240

Max length of index expression 255

Max length of conditional expression 255

Max tags in a .CDX index 255

Max tags in an .NSX index 64

Max open index files per table 249 (2)

Max open index files per task 249 (2)

Fields / Columns

Max characters per field: Character 1023 (3)

Max characters per field: Numeric 20

Max characters per field: Logical 1 (4)

Max characters per field: Date 8 (4)

Max characters per field: memo ref in DBF 10 (4)

Max characters per memo in DBT/FPT/SMT 64k

Max BLOB size stored in a memo 16 Mb

Max characters in a field name 10

Numeric precision 16

Notes

(1) Actual file size is limited to 2GB

(2) 255 file handles per task.

(3) Up to 32k if sx_GetRecord is used to read the entire record buffer.

(4) Non-adjustable field size.