The table below lists the maximums for CodeBase, including
known maximums for retaining xBASE file compatibility.
| Description |
CodeBase Maximum Limit |
Note |
| Number of Open Files |
Limited only by the compiler and the operating environment. |
|
| Data File Size |
Limited only by maximum number of records with large file support turned on
1,000,000,000 bytes with large file support turned off
|
FoxPro has a limit of 2 GB.
|
| Number of Records per table |
2,147,483,647 (2.1 billion) |
FoxPro has a limit of 1,000,000,000.
|
| Record Width |
Limited only by maximum number of fields and maximum field width with large file support turned on
65534 bytes with large file support turned off
|
FoxPro has a limit of 65500 bytes.
dBASE has a limit of 128 bytes.
Clipper has a limit of 1022 bytes.
|
| Number of Fields per table |
2046
|
FoxPro has a limit of 255.
dBASE has a limit of 128.
Clipper has a limit of 1022.
|
| Field Width |
65533 bytes
|
FoxPro has a limit of 254 bytes.
dBASE has a limit of 254 bytes.
|
| Floating Point/Numeric Field Width |
19 |
|
| Memo File Size |
(2,147,483,647 memo blocks) * (Memo Block Size) with large file support turned on
4 GB with large file support turned off
|
|
| Memo Block Size |
32768 bytes (32 kB) |
|
| Memo Entry Size |
(maximum value of an unsigned integer) minus (overhead)
The overhead may vary depending on compiler or
platform but should never exceed 100 bytes.
Therefore, if the system uses a 32-bit
unsigned integer, the memo entry size is:
4,294,967,296 - 100 = 4,294,967,196 bytes (approximately 4 GB)
|
|
| Number of tags per index file |
Unlimited when using the FoxPro file format
47 when using the dBASE IV file format
1 when using the Clipper file format
|
|
| Index File Size |
2048 GB with 512-byte index blocks and large file support turned on
4096 GB with 1024-byte or larger index blocks and large file support turned on
4 GB with large file support turned off and multi-user support disabled
1 GB with large file support turned off and multi-user support enabled
|
|
| Index Key Size |
240 bytes when using the FoxPro file format
102 bytes when using the dBASE IV file format
388 bytes when using the Clipper 5.x file format
|
|
