robert_lee141 wrote:

> Thank you Ann...I actually don't need to add any more tables to the
> db, but I do need to increase the rows in the one table by several
> million records. What i'm understanding is that it won't be a
> problem to go well over 4GB, even up to 40GB? How can I tell the
> size limit for a single table?
>

If I recall correctly, you're running InterBase 6.0. That (elderly)
version does have a 4Gb file size limit. Previous versions just
trashed the database if it went over 4Gb, so getting an error is
an improvement. More modern versions of InterBase and all versions
of Firebird allow virtually unlimited file sizes. So, if you want
to stay with your (elderly) InterBase 6.0, you should add additional
files to the database.

Once you have additional files, a single table can grow up to about
40Gb - it depends slightly on the records size. Firebird 2 removes
that limit.


Regards,


Ann