Firebird korlátok

Firebird limits

ITEM Firebird 2.X Firebird 1.5
Maximum size of the database Virtually unlimited
basis using the bd
in several files.
32 Tb into several files.
Maximum size of the database in a single file
Several terabytes in the vast majority
platforms, the limit is defined
by the system files (4GB or 2 Gb on some platforms, eg Windows 98)
As Firebird 2.x
Maximum  number of database files 64.535 As Firebird 2.x
Maximum number of tables 64.535 As Firebird 2.x
Maximum size of a table 32 Tb As Firebird 2.x
Maximum size of an external file table
2 Gb As Firebird 2.x
Maximum numer of row per table
> 16 Billions (This is not verified, this data is theoretical). 4 Billions
Maximum row size 64.535 bytes (64 KB) As Firebird 2.x
Maximum data page size
16 Kb
Note: The size can be of 1024,2048,4096,8192 and 16384. Size 1024 is not recommended.
As Firebird 2.x
Maximum number of columns per table It depends on the type of data used.

(Example: 16384 INTEGER (4-byte) values per row.)

Note: 8-Byte are stored for each BLOB or ARRAY
The size of the BLOB or ARRAY is not taken into account the size of the row.

As Firebird 2.x
Maximum number of index per table 65.535 As Firebird 2.x
Maximum main index size 4096 when the page size is 16 Kb
(Limited to one quarter the size of the pagination of the database.)Note: character limit decreases by column
when the character is set comomultibyte;

(Example: 16384 INTEGER (4-byte) values per row.)

Note: 8-Byte are stored for each BLOB or ARRAY
The size of the BLOB or ARRAY is not taken into account the size of the row.

Proponer una traducción mejor
252 bytes
Maximum number of indices for datable 4.398.046.511.104 As Firebird 2.x

Limits Firebird data types

NAME SIZE Range / Accuracy DESCRIPTION
Varchar(n) n Caracteres 1 to 32.767 Bytes Array of characters or string.

NB, if Selects the Multi-Byte reduces
the number of possible characters accordingly.

Smallint 16 bits -2ˆ15 to 2ˆ15-1 Short integer
Integer 32 bits -2ˆ31 to 2ˆ31-1 Long Integer
Float 32 bits 3.4×10ˆ-30 to 3.4×10ˆ38 Real number with 7 digits
Double Precisión 64 bits 1.7×10ˆ-308 to 1.7×10ˆ308 Real number with 16 digits
Timestamp 64 bits (2×32 bits) 1 jan 100 CE to 28 feb 32768 CE Includes time and date in two 32-bit structures.
Date 32 bits 1 jan 100 CE to 28 feb 32768 CE Date. Example: 12/10/1977
The time is not stored in this type.
Time 32 bits 0:00 to 23:59,9999 Type Time. Example: 12:00:00
BLOB <32 GB Indeterminate storage variables.
Texts, images, binaries, etc.
Numeric
(precision,scale)
Variable
(16,32 or 64 bits)
According to the desired specification Real numbers with the number of decimals defined.
Example: Numeric (10.3)
3462344634.345

Forrás

Advertisements

Vélemény, hozzászólás?

Adatok megadása vagy bejelentkezés valamelyik ikonnal:

WordPress.com Logo

Hozzászólhat a WordPress.com felhasználói fiók használatával. Kilépés / Módosítás )

Twitter kép

Hozzászólhat a Twitter felhasználói fiók használatával. Kilépés / Módosítás )

Facebook kép

Hozzászólhat a Facebook felhasználói fiók használatával. Kilépés / Módosítás )

Google+ kép

Hozzászólhat a Google+ felhasználói fiók használatával. Kilépés / Módosítás )

Kapcsolódás: %s