-----Original Message-----
From: Alfred Thomas [mailto:alfred@...]
Sent: Wednesday, December 10, 2003 4:35 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Technical info


Hi all

Can anyone please tell me where I can find information on the maximum
file
size of a FireBird 1.5 database, the maximum number of records, as well
as
any other limitations. According to the Interbase 6 operations guide,
the
max database size is 4GB per file. But we have a 8.5GB single file DB.

Regards
Alfred Thomas






InterBase Technical Specification




Database Statistics (Upper Limits)


Maximum size of database: 32TB using multiple files; largest recorded
InterBase database in production is over 200GB

Maximum size of one file: 4GB on most platforms; 2GB on some platforms

Maximum number of tables: 64K Tables

Maximum size of one table: 32TB

Maximum number of rows per table: 4GB Rows

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

Maximum number of indexes per table: Dependent upon a combination of the
page size, the length of the index and key names.

Maximum number of indexes per database: 4G indexes


InterBase Datatype Specifics

Name Size Range/Precision Description
Varchar(n) n chars 1 to 32767 bytes Variable length
char or text string
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.4 x 10^-38 to 3.4 x 10^38 7 digit
precision
Double Precision 64 bits 1.7 x 10^-308 to 1.7 x 10^308
15 digit precision
*Timestamp 64 bits 1 Jan 100 a.d. to 28 Feb 32768 a.d.
Includes time and date
**Date 32 bits 1 Jan 100 a.d. to 29 Feb 32768 a.d.
*Time 32 bits 0:00 AM to 23:59.9999 PM
Blob <32GB Stores data of variable indeterminate size
***Numeric (precision, scale) Variable (16, 32, or 64)
specifies exactly precision digits of precision Example: Numeric(10,3)
holds numbers accurately in the following format: ppppppp.sss
***Decimal (precision, scale) Variable (16, 32, or 64)
specifies at least precision digits of precision Example:
Decimal(10,3) holds numbers accurately in the following format:
ppppppp.sss

* New to InterBase V6.0
** Date datatype holds both date and time information in versions prior
to V6.0
*** precisions greater than 9 are stored as exact numerics in V6.0 and
non-exact double precision in previous versions.





Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12ckg9hq1/M=258297.4271147.5470572.4049140/D=eg
roupweb/S=1705115386:HM/EXP=1071131719/A=1683962/R=0/*http://www.techsmi
th.com/rdr/ban/syah/default.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4271147.5470572.4049140/D=egrou
pmail/S=:HM/A=1683962/rand=235498077>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]