BDE Limits
The following tables list the Borland Database Engine and Native dBASE /Paradox File Maximum Limits for both 16 and 32 bit Versions of BDE. If you find you cannot reach these limits, or are getting an out of memory error, increasing your SHAREDMEMSIZE in BDE Config to 4096 or more should allow you to reach these limits.
GENERAL LIMITS
|
Description |
Limit |
|
Clients in system |
48 |
|
Sessions per client (3.5 and earlier, 16 Bit, 32 Bit) |
32 |
|
Session per client (4.0, 32 Bit) |
256 |
|
Open databases per session (3.5 and earlier, 16 Bit, 32 Bit) |
32 |
|
Open databases per session (4.0, 32 Bit) |
2048 |
|
Loaded drivers |
32 |
|
Sessions in system (3.5 and earlier, 16 Bit, 32 Bit) |
64 |
|
Sessions in system (4.0, 32 Bit) |
12288 |
|
Cursors per session |
4000 |
|
Entries in error stack |
16 |
|
Table types per driver |
8 |
|
Field types per driver |
16 |
|
Index types per driver |
8 |
|
Size of configuration (IDAPI.CFG) file |
48K |
|
Size of SQL statement |
64K |
|
Size of SQL statement (RequestLive=True) |
4K |
|
Size of SQL statement |
6K |
|
Record buffer size (SQL or ODBC) |
16K |
|
Table and field name size in characters |
31 |
|
Stored procedure name size in characters |
64 |
|
Fields in a key |
16 |
|
File extension size in characters |
3 |
|
Table name length in characters |
260 |
|
Path and file name length in characters |
260 |
DBASE Limits
|
Description |
Limit |
|
Open dBASE tables per system (16 Bit) |
256 |
|
Open dBASE tables per system (BDE 3.0 - 4.0, 32 Bit) |
350 |
|
Open dBASE tables per system (BDE 4.01, 32 Bit) |
512 |
|
Record locks on one dBASE table (16 and 32 Bit) |
100 |
|
Records in transactions on a dBASE table (32 Bit) |
100 |
|
Records in a table |
1 Billion |
|
Bytes in .DBF (Table) file |
2 Billion |
|
Size in bytes per record (dBASE 4) |
4000 |
|
Size in bytes per record (dBASE for Windows) |
32767 |
|
Number of fields per table (dBASE 4) |
255 |
|
Number of fields per table (dBASE for Windows) |
1024 |
|
Number of index tags per .MDX file |
47 |
|
Size of character fields |
254 |
|
Open master indexes (.MDX) per table |
10 |
|
Key expression length in characters |
220 |
Paradox Limits
|
Description |
Limit |
|
Tables open per system (4.0 and earlier, 16 Bit, 32 Bit) |
127 |
|
Tables open per system (4.01, 32 Bit) |
254 |
|
Record locks on one table (16Bit) per session |
64 |
|
Record locks on one table (32Bit) per session |
255 |
|
Records in transactions on a table (32 Bit) |
255 |
|
Open physical files (4.0 and earlier, 16 Bit, 32 Bit) |
512 |
|
1024 Open physical files (4.01, 32 Bit) |
1024 |
|
Users in one PDOXUSRS.NET file |
300 |
|
Number of fields per table |
255 |
|
Size of character fields |
255 |
|
Records in a table |
2 Billion |
|
Bytes in .DB (Table) file |
2 Billion |
|
Bytes per record for indexed tables |
10800 |
|
Bytes per record for non-indexed tables |
32750 |
|
Number of secondary indexes per table |
127 |
|
Number of fields in an index |
16 |
|
Concurrent users per table |
255 |
|
Megabytes of data per BLOb field |
256 |
|
Passwords per session |
100 |
|
Password length |
15 |
|
Passwords per table |
63 |
|
Fields with validity checks (32 Bit) |
159 |
|
Fields with validity checks (16 Bit) |
63 |