Some current internal limits of BDE

By: Quinn Wildman

Abstract: All the limits we could think of.

Some current internal limits of BDE

Description:
Here are the maximum limits for some common BDE objects. 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

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)
Billion records in a table
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

Server Response from: ETNASC04