Some BDE Internal Limits
Here are the maximum limits for some common BDE objects. If you find that 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
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 Bit/32 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 Bit/32 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 |
Archive of https://edn.embarcadero.com/article/15159