Xbase 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 file size

 

Windows with NTFS

2 gigabytes (2,147,483,648 bytes) multiplied by record length

Windows with FAT32

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

NetWare 5 and greater with NSS file systems*

2 gigabytes (2,147,483,648 bytes) multiplied by record length

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+

2 gigabytes (2,147,483,648 bytes) multiplied by record length

Maximum index size

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

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)

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

10 characters for traditional Xbase DBFs. 128 characters for Visual FoxPro (VFP) tables associated with a data dictionary.

Maximum index order name length

10 characters

Characters allowed in field names

Characters ‘a’-‘z’ and ‘A’-‘Z’, digits ‘0’-‘9’, and the underscore ‘_’ character

Characters allowed in index order names

Characters ‘a’-‘z’ and ‘A’-‘Z’, digits ‘0’-‘9’, and the underscore ‘_’ character

Maximum amount of data per binary/image/BLOB field

4 gigabytes

Maximum number of fields per table

2035

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 locks

Limited by memory

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

 

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

NTX

256 bytes

 

IDX (non-compact)

220 bytes

 

IDX (compact)

512 bytes**

 

CDX

512 bytes**

 

 

 

Maximum length of evaluated key expression

NTX

256 bytes

 

IDX (non-compact)

100 bytes

 

IDX (compact)

240 bytes

 

CDX

240 bytes

 

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