Firebird Technical Specifications Updated 20070716 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 (4byte) values per row.) Note: 8byte 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; nonbinary 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, multibyte character sets reduce number of possible characters proportionately
Smallint
16 bits
2^15 to 2^151
Signed short (word)
Integer
32 bits
2^31 to 2^311
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 32bit 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
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.
the agencies will have to offer 3 other color combinations as per specification given below and supply accordingly. A common colour/design combination is ...
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 ...
Page 3 of 24. PS all PowerClamp Technical Specifications March 17 .pdf. PS all PowerClamp Technical Specifications March 17 .pdf. Open. Extract. Open with.
http://www.nrc.gov/reading-rm.html. Publicly released records ... 2. The National Technical Information Service. Springfield, VA 22161B0002 www.ntis.gov.
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 ...
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
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
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 ...
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 ...
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
May 11, 2012 - enabled analytics. This GPKG data container ..... GEOS is widely used by both free and commercial software packages. Quantum GIS (QGIS) is.
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.
... with significant input from stakeholders, based on best available science and .... 7.3 Equipment manuals, Indoor airPLUS label, and certificate provided for ...
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.
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
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
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 ...