Bogusław Brandys wrote:

> BogusBaw Brandys wrote:
>
>>>Hello,
>>>
>>>
>>>I heard about 2GB single table limit in Firebird 1.0 and 1.5.Is it true ?
>>>
>>>
>>>Can I avoid it using ALTER DATABASE ADD FILE filename to spread database
>>>into a couple of files each one smaller then 2GB ?
>>>
>>>
>>>Regards
>>>Boguslaw Brandys
>
>
> Sorry for this bad question.
>
> 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 , but I'd like to know if splitting database
> over multiple files could help. Does Firebird balance table fill
> spreading over multiple files in such case ?
>
> Theoretical question.
> Thank You.
>
>
> Boguslaw Brandys
>
>

And I should apologize once again :-( because I realized that it should
be probably moved to firebird-general list.

Regards
Boguslaw Brandys
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links