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
(RequestLive=False)

64K

Size of SQL statement (RequestLive=True)

4K

Size of SQL statement
(RequestLive=True) (4.01, 32 Bit)

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
(some servers might have other limits)

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)
(DB, PX, MB, X??, Y??, VAL, TV)

512

1024 Open physical files (4.01, 32 Bit)
(DB, PX, MB, X??, Y??, VAL, TV)

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