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 300 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.

ANNEXURE IV SECTION 3: TECHNICAL SPECIFICATIONS
the agencies will have to offer 3 other color combinations as per specification given below and supply accordingly. A common colour/design combination is ...

ANNEXURE IV SECTION 3: TECHNICAL SPECIFICATIONS
A common colour/design combination is desired for the entire state for the true spirit of uniformity among children. a) Material to be supplied as per detailed ...

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.

PS all PowerClamp Technical Specifications March 17 .pdf ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. PS all ...

NUREG-1431, Vol 1, Rev 4, "Standard Technical Specifications ... - NRC
available free, to the extent of supply, upon written request as follows: ... and consistency. Users may access the STS NUREGs in the PDF format at (http://www.nrc.gov). Users may print or download copies from the NRC Web site. ...... Verification of

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.

LoRa Outdoor Gateway (ODU) Technical Specifications 20170817.pdf
This LoRa Outdoor Gateway is specifically designed for wide area smart city. applications. Applications include, but not limited to automatic meter reading, monitoring. fault indicators, monitoring street lights, etc. Typical deployment is using star

Firebird/InterBase - Date functions
Number of days in month ... get Day of Week by ISO standard, use: .... Because IB5 does not support EXTRACT function, we can just test whether February 29th ...

Stock Specifications - Pipes
The surface condition complies with API 5L Annex E. (b) External surface of pipe shall be coated with a layer of varnish. NDT. All pipes will be ultrasonic tested ...

GLUT Specifications - Hippo Games
Nov 13, 1996 - The OpenGL Utility Toolkit (GLUT) is a programming interface with ANSI C and FORTRAN bindings for writ- ing window system .... The advantage of a builtin event dispatch loop is simplicity. GLUT contains routines for rendering fonts and

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.

GLUT Specifications
Nov 13, 1996 - 14.3 Error Checking and Reporting . ...... GLUT CURSOR UP DOWN Bi-directional pointing up & down. GLUT CURSOR LEFT RIGHT ...

manuscript specifications
Rediset WMX®, however, had only minor effect on the binder ... temperature by 20°C up to 50°C from the conventional Hot Mix Asphalt (HMA) without compromising .... The illustration (Figure 5) also demonstrates the crystallization range of.

Construction Specifications - EPA
... with significant input from stakeholders, based on best available science and .... 7.3 Equipment manuals, Indoor airPLUS label, and certificate provided for ...

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

Campaign Limits
regulation ranging from information and disclosure requirements to limits on campaign contribu- tions and/or ... addition, few countries provide information on the characteristics and campaign spending of both ...... that are correlated with our poli

Audio Specifications
alters a pure input signal in any way other than chang- ing its magnitude. The most .... Alternatively, noise filters, or weighting filters, are used when measuring ...