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?



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

>
> robert_lee141 wrote:
> >
> > 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?
> >
>
> You can add more files to the database - check the ALTER DATABASE
> statement. The size limit for a single table is about 40 Gb. More
> modern versions (e.g. Firebird 1.0, 1.5, etc.) eliminate the file
> size limit.
>
> Regards,
>
>
> Ann
>