Advantage Proprietary File Format Specifications

Advantage Concepts

  Previous topic Next topic  

Description

Length

Maximum number of index orders per compound index file

50

Maximum number of index files open per table

15

Maximum table size

 

Windows 98/ME

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

Windows with NTFS

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

Windows with FAT32

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

NetWare 5 and greater with NSS file systems*

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

NetWare 5 and greater with traditional file systems

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

Linux pre-2.1.2 - 11 glibc and pre-2.4 kernel

2 gigabytes (2,147,483,648 bytes)

Linux glibc 2.1.2 - 11+ with kernel 2.4+

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

Maximum index file size

 

Windows 98/ME

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

Windows with NTFS

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

Windows with FAT32

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

NetWare 5 and greater with NSS file systems*

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

NetWare 5 and greater with traditional file systems

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

Linux pre-2.1.2 - 11 glibc and pre-2.4 kernel

2 gigabytes (2,147,483,648 bytes)

Linux glibc 2.1.2 - 11+ with kernel 2.4+

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

Maximum memo file size

 

Windows 98/ME

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

Windows with NTFS

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

Windows with FAT32

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

NetWare 5 and greater with NSS file systems*

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

NetWare 5 and greater with traditional file systems

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

Linux pre-2.1.2 - 11 glibc and pre-2.4 kernel

2 gigabytes (2,147,483,648 bytes)

Linux glibc 2.1.2 - 11+ with kernel 2.4+

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

 

* With NetWare 5 and greater, file sizes greater than 4GB requires a special build of ads.nlm in conjunction with a certain NetWare support pack. Contact your Advantage distributor for more information.

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