Hi,

At June 17, 2005, 06:56, Bogusław Brandys wrote:

> My system : embedded FB 1.5.2 on Windows XP Home

> Correct question :

> I know that single table limit is quite low ;-) (40GB - 80 GB depending
> on table record size). I have database with two tables storing document
> headers and details. I think that detail table could reach this limit
> during year or two. I suppose that it's not a problem because FB 2.0
> should became stable sooner ,

There have been some changes in respects to table size limit in FB 2.0
and that limit is much much higher.

> but I'd like to know if splitting database
> over multiple files could help.

No. Because the limit is related to the record pointer which is a
32-bit integer(I'm not sure if it's signed or unsigned), and in FB 2.0
it has been bumped up to 40 or 64 bits (not quite sure here). So as
you can see the limit is much much higher in FB 2.0.

> Does Firebird balance table fill
> spreading over multiple files in such case ?

No.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)