DBMS Limitations:
IBM Informix
No practical database limits other than those imposed by the
hardware and operating system.
KE Texpress
KE Texpress imposes no practical database limits other than those
imposed by the hardware and operating system. Therefore the
system is applicable to databases of all sizes, from a few objects to
hundreds of millions of objects.
http://www.kesoftware.com/texpress/engine.html
Microsoft Acces 97
Max mdb file size: 1GB
(working with JET
Max users connected to database: 255
database engine)
Max object name length: 64
Max objects in database: 32768
Max record length (without Memos and BLOBs): 2048
Max fields in table: 255
Max modules in database: 1024
Max password length: 14
Max user/group name length: 20
Max nested transactions: 7
Microsoft Access
Max mdb file size: 2GB
2000
/
XP
Max users connected to database: 255
(if used with MSDE as
Max object name length: 64
database engine see
Max objects in database: 32768
Microsoft MSDE 2000)
Max record length (without Memos and BLOBs): 2048
Max fields in table: 255
Max modules in database: 1000
Max password length: 14
Max user/group name length: 20
Max table size: 1GB
Microsoft MSDE 2000
Differences to Microsoft SQL Server:
Max size of addressable ram: 2 GB
Max number of usable processors: 2
Max number of current processes, queries: 5
No graphical administration tool like Enterprise Manager
Microsoft SQL Server
No practical database limits other than those imposed by the
hardware and operating system.
Microsoft Visual Foxpro 8
No practical database limits other than those imposed by the
hardware and operating system.
MySql 3.23
8 million terabytes practical database limit depending on the
selected hardware and operating system.
Oracle
No practical database limits other than those imposed by the
hardware and operating system.
30/44
<
New Page 1
Filemaker Web Hosting