Subject Re: [firebird-support] Large Database Multi File support
Author Alexandre Benson Smith
At 14:51 18/03/2004 -0600, you wrote:

>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.
>Version: GnuPG v1.2.3 (MingW32)


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
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil


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

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