Description

Length

Maximum number of index orders per compound index file

256

Maximum number of index files open per table

15

Maximum table size

Windows with NTFS

16 exabytes (18,446,744,073,709,551,616 bytes)

Windows with FAT32

4 gigabytes (4,294,967,296 bytes)

Linux

8 exabytes (9,223,372,036,854,775,807 bytes)

Maximum index file size

Windows with NTFS

4 gigabytes multiplied by (Index Page Size) : Max 35 terabytes

Windows with FAT32

4 gigabytes (4,294,967,296 bytes)

Linux

4 gigabytes multiplied by (Index Page Size) : Max 35 terabytes

Maximum memo file size

Windows with NTFS

4 gigabytes multiplied by (Memo Page Size) : Max 4 terabytes

Windows with FAT32

4 gigabytes (4,294,967,296 bytes)

Linux

4 gigabytes multiplied by (Memo Page Size) : Max 4 terabytes

Maximum database size

No maximum - limited by disk space only

Maximum number of records per table

2 billion.

Maximum record length

65530 bytes

Maximum field name length

128 characters

Maximum index order name length

128 characters

Characters allowed in field names

Any character value except 0 (NULL), ‘;’ (a semi-colon), or ‘,’ (a comma)

Characters allowed in index order names

Any character value except 0 (NULL), ‘;’ (a semi-colon), or ‘,’ (a comma)

Maximum amount of data per binary/image/BLOB field

4 gigabytes

Maximum traditional record filter expression text length

65,534 characters

Maximum Advantage Optimized Filter (AOF) expression text length

65,534 characters

Maximum number of transactions

Limited by memory

Maximum number of connections

Limited by memory

Maximum number of files opened simultaneously

Limited by memory

Maximum number of tables opened per connection

Limited by memory

Maximum number of locks

Limited by memory

Maximum length of key expression text and maximum length of conditional expression text

512 bytes**

Maximum length of evaluated key expression

4082 bytes***