At 14:51 18/03/2004 -0600, you wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Hey everyone,
>Just wondering if there is a way to create a large database (more than
>four gigs), without having to specify a lot of seconday databases (like
>is there a way to have it automatically generate secondary filenames
>based on the original name and just create them as needed?). Also, does
>firebird suffer any significant performance penalties if its using
>multifile databases? Any answer would be appreciated.
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.2.3 (MingW32)
>
>iD8DBQFAWgvrvWeCZ4RLdzYRAuIIAJ9mdrfppPSMxmzeeb3Cl3lDtTOu4ACfantE
>AWRLngOrNTjCIm5ou4W0grU=
>=xnIY
>-----END PGP SIGNATURE-----

Hi,

There is a 64 bit version, but I never used it.

You could create a some aditional files, that will be used when necessary,
but there is no automatic way to create files. One file will be used until
it fills up, and then the subsequent file will be used.

There is no penalty using mutiple files... And performance gain could be
expected if each file resides on diferent disk/controller... But RAID can
give you better results.

One thing that brings on when LARGE databases is mentioned is the table
size limit (around 60GB if I remember right), there are developers working
on this issue on FB 2.0.


See You !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004


[Non-text portions of this message have been removed]