|Subject||RE: [firebird-support] Database File Size|
> I am running FB 2.0 on Windows Server 2003 Enterprise. Is anyoneaware
> of a file size limitation or recommendation for the database thatwould
> lend itself towards better performance. Right now I am using a singleThere is no filesize limit for FB. I have heard of 100GB databases
> file for the DB and it is a little over 8 GB.
without any problems.
And a single file is the best in terms of database mobility. The
secondary file support was originally developed when RAID system hadn't
really been developed and when the notion of a multi-terabyte disk
volume was a dream. Though it works, is has some issues which affect
database maintenance tasks and general mobility.