At 10:36 AM 5/25/2004, Eduardo Gamboa wrote:

>
>Where can I find information about all the limits that apply to DB File
>Size, Table Size, Blob fields, etc.

Until quite recently, 4Gb was considered quite large for anything, so lots of
limits in the database weren't considered. Now, databases are much larger and
we've had to look again at some limits.

Lets see. The maximum database size is 4Gb * 16Kb. The maximum size for a
single
file is the limit of the operating system or disk size. Tables consist of
at most
4G of records, usually less due to the way record identifiers are
computed. That
translates to about 62Gb of data if records are about 100 bytes long when
compressed.
Blob fields can be 16Kb ^^ 3, or substantially larger than a database.

The limit on the number of records in a table will be relaxed in an
upcoming version
of Firebird.


Regards,


Ann