Firebird Technical Specifications Updated 2007­07­16 and subject to review

Database Limits Item

Firebird 2.x

Firebird 1.5

Maximun size of database

Practically unlimited using multiple  database files (largest known database  is over 980 GB)

Maximum size of one database file

Multiple terabytes on most platforms;  Same limited by file systems (4 GB or 2 GB on  somes platforms)

Maximum number of database files

64.535

Same

Maximum number of tables

64.535

Same

Maximum size of one table

~32 TB

~36 GB

Maximum size of external table file

2 GB

Same

Maximum number of rows per table

> 16 Billion (not been measured beyond  ~ 4 Billion this). Note: 1 Billion is 1024^3

Maximum row size

65.536 bytes (64 KB)

Same

Maximum database page size

16 KB Note: Page size (PAGE_SIZE) can be  1024, 2048, 4096, 8192 or 16384. Size  1024 is not recommended.

Same

Maximum number of columns per  table

Depends on data types used. (Example: 16384 INTEGER (4­byte) values  per row.) Note: 8­byte ID is stored for each BLOB or ARRAY reference; size of BLOB  or ARRAY data is not counted in row size.

Maximum number of indexes per table 65.535 Maximum size (total width) of index  key

Maximum number of indexes per  database

32 TB using multiple files

Same

4096 bytes when page size is 16 KB  252 bytes (limited to ¼ of database page size). Important: Limit decreases for character  columns when character set is multi­ byte; non­binary collation further reduces  limit. 4.398.046.511.104

Same

Data Type Specifics Name

Size

Range/Precision

Description

Varchar(n)

n chars

1 to 32,767 bytes

Variable length char or text string. NB,  multi­byte character sets reduce  number of possible characters  proportionately

Smallint

16 bits

­2^15 to 2^15­1

Signed short (word)

Integer

32 bits

­2^31 to 2^31­1

Signed long (longword)

Float

32 bits

3.4x10^­38 to 3.4x10^38

Accurate to 7 digits

Double Precision

64 bits

1.7x10^­308 to 1.7x10^308

Accurate to 15 digits

Timestamp

64 bits (2x32 bits)

1 jan 100 CE  to  28 feb 32768 CE

Includes time and date as two 32­bit  structures

Date

32 bits

1 jan 100 CE  to  28 feb 32768 CE

Date only. Time part is not stored.

Time

32 bits

0:00 to 23:59,9999

BLOB

< 32 GB

Stores data of variable indeterminate  size

Numeric  (precision,scale)

Variable (16, 32 or  specifies exactly precision digits of  64 bits) precision

Example: Numeric(10,3) holds  numbers accurately in the following  format: ppppppp.sss

Copyright © 2000-2008, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. www.firebirdsql.org

Firebird Technical Specifications Database Limits

Database Limits. Item. Firebird 2.x. Firebird 1.5. Maximun size of database. Practically unlimited using multiple database files (largest known database.

417KB Sizes 0 Downloads 107 Views

Recommend Documents

ANNEXURE IV SECTION 3: TECHNICAL SPECIFICATIONS
of Kerala, however in case if the SMCs/PTAs/Schools request for other color combinations, the agencies will have ... a) Material to be supplied as per detailed Technical Specifications given below: i. Shirting .... top with duppatta. Shirting. Shirt.

PS all PowerClamp Technical Specifications March 17 .pdf ...
Page 3 of 24. PS all PowerClamp Technical Specifications March 17 .pdf. PS all PowerClamp Technical Specifications March 17 .pdf. Open. Extract. Open with.

NUREG-1431, Vol 1, Rev 4, "Standard Technical Specifications ... - NRC
http://www.nrc.gov/reading-rm.html. Publicly released records ... 2. The National Technical Information Service. Springfield, VA 22161B0002 www.ntis.gov.

LoRa Indoor Gateway (IDU) Technical Specifications 20170817.pdf ...
Page 1 of 1. LoRa Indoor Gateway (IDU) Technical Specifications 20170817.pdf. LoRa Indoor Gateway (IDU) Technical Specifications 20170817.pdf. Open.

GeoPackage Specifications -
May 11, 2012 - enabled analytics. This GPKG data container ..... GEOS is widely used by both free and commercial software packages. Quantum GIS (QGIS) is.

GeoPackage Specifications -
May 11, 2012 - It is deployed and supported by Google on Android and Apple on IOS ..... 7.2.10.1. ST_IsRing tests if an Curve value is a ring. 4.1.4.1. 2.1.5.1.

GLUT Specifications - Hippo Games
Nov 13, 1996 - the portability of the program's OpenGL rendering code, the program itself will be window system dependent. Testing and ... Menu Management. These routines create and control pop-up menus. Callback .... 1.6 Terminology. A number of ter

specifications for review
Nov 12, 2008 - UNIT 21. DOUBLEGATE LANE. RAWRETH, WICKFORD. ESSEX. SS11 8UD. TEL. 01268 570020. FAX. 01268 570700. DATE: SCALE:.