Subject RE: [firebird-support] Database File Size
Author Leyne, Sean
> I am running FB 2.0 on Windows Server 2003 Enterprise. Is anyone
> of a file size limitation or recommendation for the database that
> lend itself towards better performance. Right now I am using a single
> file for the DB and it is a little over 8 GB.

There is no filesize limit for FB. I have heard of 100GB databases
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.