Comparison of Relational Database Management Systems - Limits

Limits

Information about data size limits.

Max DB size Max table size Max row size Max columns per row Max Blob/Clob size Max CHAR size Max NUMBER size Min DATE value Max DATE value Max column name size
4th Dimension limited ? ? 65135 200 GB (2 GiB Unicode) 200 GB (2 GiB Unicode) 64 bits ? ? ?
Advantage Database Server Unlimited 16 EiB 65530 B 65135 / (10+ AvgFieldNameLength) 4 GiB ? 64 bits ? ? 128
Apache Derby Unlimited Unlimited Unlimited 1012 (5000 in views) 2 147 483 647 chars 254 (VARCHAR: 32672) 64 bits 0001-01-01 9999-12-31 128
CUBRID 2 EB 2 EB Unlimited 6400 Unlimited 1 GB 64 bits 0001-01-01 9999-12-31 254
Drizzle Unlimited 64 TB 8 kB 1000 4 GB (longtext, longblob) 64 kB (text) 64 bits 0001 9999 64
DB2 512 TiB 512 TB 32 677 B 1012 2 GB 32 KiB) 64 bits 0001 9999 128
Empress Embedded Database Unlimited 263-1 bytes 2 GB 32767 2 GB 2 GB 64 bits 0000-01-01 9999-12-31 32
FileMaker 8TB 8TB 8TB 256,000,000 4GB 10^9 characters 10^9 numbers w/ range 10^-400 to 10^400 0001-01-01 4000-12-31 100
Firebird Unlimited1 ~32 TB 65 536 B Depends on data types used. 2 GB 32 767 B 64 bits 100 32768 31
HSQLDB 64 TB Unlimited8 Unlimited8 Unlimited8 64 TB7 Unlimited8 Unlimited8 0001-01-01 9999-12-31 128
H2 64 TB Unlimited8 Unlimited8 Unlimited8 64 TB7 Unlimited8 64 bits -99999999 99999999 Unlimited8
Max DB size Max table size Max row size Max columns per row Max Blob/Clob size Max CHAR size Max NUMBER size Min DATE value Max DATE value Max column name size
Informix Dynamic Server ~128 PB ~128 PB 32 765 bytes (exclusive of large objects) 32765 4 TB 32765 1032 01/01/000110 12/31/9999 128 bytes
Ingres Unlimited Unlimited 256 kB 1024 2 GB 32 000 B 64 bits 0001 9999 256
InterBase Unlimited1 ~32 TB 65 536 B Depends on data types used. 2 GB 32 767 B 64 bits 100 32768 31
Linter SQL RDBMS Unlimited 230 rows 64 kB (w/o BLOBs), 4 GB (BLOB) 250 4 GB 4 kB 64 bits 0001-01-01 2099-12-31 128
Microsoft Access (JET) 2 GB 2 GB 16 MB 255 64 kB (memo field), 1 GB ("OLE Object" field) 255 B (text field) 32 bits 0100 9999 64
Microsoft Visual Foxpro Unlimited 2 GB 65 500 B 255 2 GB 16 MB 32 bits 0001 9999 ?
Microsoft SQL Server 524,272 TB (32 767 files * 16 TB max file size) 524,272 TB 8060 bytes (Unlimited)6 30000 2 GB 2 GB6 126 bits2 0001 9999 128
Microsoft SQL Server Compact (Embedded Database) 4 GB 4 GB 8060 bytes 1024 500 MB 4000 126 bits 2 0001 9999 128
MySQL 5 Unlimited MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB 64 kB3 40964 4 GB (longtext, longblob) 64 kB (text) 64 bits 1000 9999 64
OpenLink Virtuoso 32 TB DB size (or 32 TB) 4K 200 2 GB 2 GB 2**31 0 9999 100
Oracle Unlimited (4 GB * block size per tablespace) 4 GB * block size (with BIGFILE tablespace) 8 kB 1000 Unlimited 4000 B 126 bits -4712 9999 30
Max DB size Max table size Max row size Max columns per row Max Blob/Clob size Max CHAR size Max NUMBER size Min DATE value Max DATE value Max column name size
Polyhedra Limited by available RAM, address space 232 rows Unlimited 65536 4 GB (subject to RAM) 4 GB (subject to RAM) 32 bits 0001-01-01 8000-12-31 255
PostgreSQL Unlimited 32 TB 1.6 TB 250-1600 depending on type 1 GB (text, bytea) - stored inline or 2 GB (stored in pg_largeobject) 1 GB Unlimited -4713 5874897 63
RDM Embedded Unlimited 248-1 rows 32 KB 1000 4 GB char: 256, varchar: 4 KB 64 bits 0001-01-01 11758978-12-31 31
RDM Server Unlimited 264-1 rows 32 KB 32768 Unlimited 32 KB 64 bits 0001-01-01 11758978-12-31 32
ScimoreDB Unlimited 16 EB 8050 B 255 16 TB 8000 B 64 bits ? ? ?
SQL Anywhere 104 TB (13 files, each file up to 8 TB (32k pages)) Limited by file size Limited by file size 45000 2 GB 2 GB 64 bits 0001-01-01 9999-12-31 ?
SQLite 128 TB (231 pages * 64 kB max page size) Limited by file size Limited by file size 32767 2 GB 2 GB 64 bits No DATE type9 No DATE type9 Unlimited
Teradata Unlimited Unlimited 64 kB wo/lobs (64 GB w/lobs) 2048 2 GB 10 000 64 bits ? 9999-12-31 Select 80991231 (date); 30
UniVerse Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited
Xeround Cloud Database Unlimited Unlimited 32GB, depending on available memory 1000 4GB 64K 64 bits 1000 9999 64
Max DB size Max table size Max row size Max columns per row Max Blob/Clob size Max CHAR size Max NUMBER size Min DATE value Max DATE value Max column name size

Note (1): Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB. Firebird 1.5.x maximum database size: 32 TB.

Note (2): limit is 1038using DECIMAL datatype

Note (3): InnoDB is limited to 8,000 bytes (excluding VARBINARY, VARCHAR, BLOB, or TEXT columns)

Note (4): InnoDB is limited to 1,000 columns

Note (6): Using VARCHAR (MAX) in SQL 2005 and later

Note (7): When using a page size of 32 kB, and when BLOB/CLOB data is stored in the database file.

Note (8): Java array size limit of 2,147,483,648 (231) objects per array applies. This limit applies to number of characters in names, rows per table, columns per table, and characters per CHAR/VARCHAR.

Note (9): Despite the lack of a date datatype, SQLite does include date and time functions, which work for timestamps between 0000-01-01 00:00:00 and 5352-11-01 10:52:47.

Note (10): Informix DATETIME type has adjustable range from YEAR only through 1/10000th second. DATETIME date range is 0001-01-01 00:00:00.00000 through 9999-12-31 23:59:59.99999.

Read more about this topic:  Comparison Of Relational Database Management Systems

Famous quotes containing the word limits:

    “Mysticism and exaggeration go together. A mystic must not fear ridicule if he is to push all the way to the limits of humility or the limits of delight.”
    —Milan Kundera (b. 1929)

    “And when discipline is concerned, the parent who has to make it to the end of an eighteen-hour day—who works at a job and then takes on a second shift with the kids every night—is much more likely to adopt the survivor’s motto: “If it works, I’ll use it.” From this perspective, dads who are even slightly less involved and emphasize firm limits or character- building might as well be talking a foreign language. They just don’t get it.”
    —Ron Taffel (20th century)

    “Whatever appeals to the imagination, by transcending the ordinary limits of human ability, wonderfully encourages and liberates us.”
    —Ralph Waldo Emerson (1803–1882)