Advantage Database Server

Advantage Proprietary File Format Specifications

Advantage Concepts

Advantage Proprietary File Format Specifications

Advantage Concepts

Previous topic Next topic  

Advantage Proprietary File Format Specifications

Advantage Concepts

Previous topic Next topic  

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***

 

** The combined length of the index key expression text and conditional expression text must not be longer than 512 bytes.

*** The maximum length of an ADI index key is limited by the index page size. Refer to Index Key Size and Page Size Relationships for the specific equations.

The maximum number of fields per table depends on field name lengths, and can be calculated by: 65135 / ( 10 + AverageFieldNameLength ). For example, if the average field name length is:

10 - then the maximum number of fields per table is 3256 fields

20 - then the maximum number of fields per table is 2171 fields

30 - then the maximum number of fields per table is 1628 fields.