Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Maximum Capacity Specifications
Previous  Top  Next



Object
Maximum sizes / numbers


Multi-User Edition
Single-User Edition
Bytes per string field
64,000 (also limited by page size)
64,000 (also limited by page size)
Bytes per BLOB field
2GB
2GB
Bytes per index
64,000 (also limited by page size)
64,000 (also limited by page size)
Bytes per row
65,400 (also limited by page size)
65,400 (also limited by page size)
Columns per index
10,000
10,000
Columns per table
65,000
65,000
UNIQUE indexes or constraints per table
30,000
30,000
Database size
32 TB (also limited by file system and OS)
32 TB (also limited by file system and OS)
Identifier length (in characters)
255
255
Locks per connection
2,147,483,647
N/A
Rows per table
2,147,483,647
2,147,483,647
Tables per database
2,147,483,647
2,147,483,647
Bytes per page
65,536
65,536
Pages per database file
2,147,483,647
2,147,483,647
Connections per database
Maximum value of configured connections before creating database file (up to 2,147,483,647)
1
Records in transaction
2,147,483,647 (also limited by available RAM)
2,147,483,647 (also limited by available RAM)
In-memory table size
2,147,483,647 (also limited by available RAM)
2,147,483,647 (also limited by available RAM)

 


        © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Dec 04, 2024