Future Filing Online Knowledgebase
Search:     Advanced search

what are the size limits of Firebird?

Article ID: 31
Last updated: 01 Oct, 2009
Add comment
Views: 192
Comments: 0


Here they are:

Maximum size of database: unlimited with Firebird 2 (using multiple files), 32TB with FB 1.x
Maximum size of one file: 16TB or more, depends on the filesystem used

Maximum number of tables: 32k Tables
Maximum size of one table: 32TB (~30GB for Firebird 1.x)
Maximum number of rows per table: 16G (4G with Firebird 1.x)

Filesystem limits apply for all those values, so please read FAQ #59 for details.

Maximum row size: 64k
Maximum number of columns per table: Depends on the datatypes you use. (Example: 16,384 INTEGER (4 byte) values per row.) Blobs only store BLOB_ID and the data is stored separately.

This article was:   Helpful Not Helpful Add comment
Prev   Next
Merge PDF or TIF files     Using Autosensing Folders

RSS