-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bogusław 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


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCsp5ktuGICzHOh+YRAlyjAJ45616XT2WIV76tDk7M0Zb0lhYYjACcC/B0
vE86gjc12PKxXOlcFNq5qzs=
=1Nbb
-----END PGP SIGNATURE-----