LOL...sounds like I may be best off upgrading to Firebird v2, would
you agree? Sounds like it would solve my issues bc i know my table
will not be anywhere near 40GB...

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

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