3. Limitations of used database management systems  

DBMS Limitations: 

4D Server

Data Files have a 64 GB limit, which corresponds to several 

hundred million records 

ftp://ftp.4d.com/ACI_PRODUCT_REFERENCE_LIBRARY/4D_PROD

UCT_WHITE_PAPERS/4th_Dimension_Tech_Overview.pdf

4th Dimension

Data Files have a 64 GB limit, which corresponds to several 

hundred million records 

ftp://ftp.4d.com/ACI_PRODUCT_REFERENCE_LIBRARY/4D_PROD

UCT_WHITE_PAPERS/4th_Dimension_Tech_Overview.pdf

Advanced Revelation

No data available 

Corel Paradox

Max users connected to database: 300 

Max users connected to table: 255 

Max fields in table: 255 

Max number of tables open per system: 127 (4.0 and earlier) 

Max number of tables open per system: 254 (4.01 32 Bit) 

Max number of record locks on one table: 64 (16Bit) per session  

Max number of record locks on one table: 255 (32Bit) per session  

Max number of records in transactions on a table: 255 (32 Bit)  

Max number of files open simultaneously: 512 Open physical files 

(4.0 and earlier)  

Max number of files open simultaneously: 1024 Open physical 

files (4.01 32 Bit)  

Max number of records in a table: 2 Billion 

Max number of bytes in .DB (Table) file: 2 Billion 

Max number of passwords per session: 100 

Max password length: 15 

Max passwords per table: 63 

http://www.thedbcommunity.com/pdox/specs.htm  

DBaseIII 

dBase III each .DBF file can be up to 2GB 

Filemaker Pro 5.5

Max file size: 2 GB 

Max users connected to database: 25 

Max number of users via a Web browser: Access to web published 

database is limited to 10 IP addresses per 12 hour period. 

Max object name length: Up to 60 characters (60 bytes) 

Max objects in database: Limited only by disk space or file size. 

Max record length: Limited by disk space or maximum file size. 

Max fields in table: Approximately 5,900 

Max number of files per disk: Limited only by disk space. 

Max number of files open simultaneously: Up to 50 files. 

http://www.filemaker.com/ti/107472.html  

Filemaker Pro 6.0

No practical database limits other than those imposed by the 

hardware and operating system. 

HDB

No data available 

29/44