--- In firebird-support@yahoogroups.com, "robert_lee141"
<robert_lee141@...> wrote:

>
> Hi All-
>
> I am using Interbase 6 on Windows 2000. I have a db with ONE table.
> What is the limit of the size of the database? I have read that for
> windows the 'filesize' max is 4gb, does this mean the size of the
> database can not exceed 4gb, or any one table? Right now my db is
> around 3.5gb...Should I not let the db get any bigger than 4?
>
> Any help is appreciated!
>

There is a limit of 2GB for FAT32 volumes, but if you are using NTFS
then the limit is higher than you can currently reach. There are
several limits, like the number of addressable rows in a table etc.
The size limits are on the compressed data, so it is hard to give a
straight forward answer.

This document should help though:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;FAQS;NAME='System+Limits'

It seems to me that it would be a trivial exercise to build a test
framework for your database. Simply insert dummy records into the
table (on a test system obviously) until it falls over. You probably
want to keep pretty close to your production system in terms of number
of inserts per transaction. Then analyse where it falls over and
assess the risk to your production database.

Adam