General BDE™ Limits |
48 |
Clients in system |
32 |
Sessions per client (3.5 and earlier 16 Bit, 32 Bit) |
256 |
Session per client (4.0 32 Bit) |
32 |
Open databases per session (3.5 and earlier 16 Bit, 32 Bit) |
2048 |
Open databases per session (4.0 32 Bit) |
32 |
Loaded drivers |
64 |
Sessions in system (3.5 and earlier 16 Bit, 32 Bit) |
12288 |
Sessions in system (4.0 32 Bit) |
4000 |
Cursors per session |
16 |
Entries in error stack |
8 |
Table types per driver |
16 |
Field types per driver |
8 |
Index types per driver |
48K |
Size of configuration (IDAPI.CFG) file |
64K |
Size of SQL statement (RequestLive=False) |
4K |
Size of SQL statement (RequestLive=True) |
6K |
Size of SQL statement (RequestLive=True) (4.01, 32 Bit) |
16K |
Record buffer size (SQL or ODBC) |
31 |
Table and field name size in characters |
64 |
Stored procedure name size in characters |
16 |
Fields in a key |
3 |
File extension size in characters |
260 |
Table name length in characters |
260 |
Path and file name length in characters |
15 |
Significant Digits |
Paradox® Limits |
127 |
Tables open per system (4.0 and earlier 16 Bit32 Bit) |
254 |
Tables open per system (4.01 32 Bit) |
64 |
Record locks on one table (16Bit) per session |
255 |
Record locks on one table (32Bit) per session |
255 |
Records in transactions on a table (32 Bit) |
512 |
Open physical files (4.0 and earlier 16 Bit32 Bit)
(DB, PX,MB, X??, Y??, VAL,TV) |
1024 |
Open physical files (4.01 32 Bit)
(DB, PX,MB, X??, Y??, VAL,TV) |
300 |
Users in one PDOXUSRS.NET file |
255 |
Number of fields per table |
255 |
Size of character fields |
2 |
Billion records in a table |
2 |
Billion bytes in .DB (Table) file |
10800 |
Bytes per record for indexed tables |
32750 |
Bytes per record for non-indexed tables |
127 |
Number of secondary indexes per table |
16 |
Number of fields in an index |
255 |
Concurrent users per table |
256 |
Megabytes of data per BLOB field |
100 |
Passwords per session |
15 |
Password length |
63 |
Passwords per table |
159 |
Fields with validity checks (32 Bit) |
63 |
Fields with validity checks (16 Bit) |
53 |
Fields with Validity checks added at onetime |
63 |
Number of Sessions with Tables open on1 System |
dBASE® Limits |
256 |
Open dBASE® tables per system (16 Bit) |
350 |
Open dBASE® tables per system (BDE™ 3.0 - 4.0,32 Bit) |
512 |
Open dBASE® tables per system (BDE™ 4.01, 32 Bit) |
100 |
Record locks on one dBASE® table (16 and 32 Bit) |
100 |
Records in transactions on a dBASE® table (32 Bit) |
1 |
Billion records in a table |
2 |
Billion bytes in .DBF (Table) file |
4000 |
Size in bytes per record (dBASE® 4) |
32767 |
Size in bytes per record (dBASE® for Windows®) |
255 |
Number of fields per table (dBASE® 4) |
1024 |
Number of fields per table (dBASE® for Windows®) |
47 |
Number of index tags per .MDX file |
254 |
Size of character fields |
10 |
Open master indexes (.MDX) per table |
220 |
Key expression length in characters |
This information obtained from: http://community.borland.com/article/0,1410,15159,00.html |
User-Reported Paradox Limitations |