12. What is the limit on the Firebird database size?
You'll probably hit the filesystem limit long before Firebird's.
Here are some facts:
Windows:
FAT12 has a 32MB file size limit
FAT16 has a 2GB file size limit (Windows NT 3 or newer)
FAT32 has a 2GB file size limit
FAT32 has a 4GB file size limit (Windows NT5 / 2000 and newer)
NTFS has a 4GB file size limit (Windows NT)
NTFS has a 16EiB file size limit (Windows NT5 / 2000 and newer)
Linux:
EXT2/EXT3 (with 4kB blocksize) has a 2TB file size limit
EXT2/EXT3 (with 8kB blocksize) has a 64TB file size limit
ReiserFS 3.6 has a 1EiB file size limit
XFS has a 8EiB file size limit
JFS (with 512b blocksize) has a 8EiB file size limit
JFS (with 4kB blocksize) has a 8EiB file size limit
Even if you hit one of those, Firebird supports multi-file databases.
If you wonder what EiB is, it's a measue like MB, GB, TB, etc. Detailed explanation can be found here:
http://physics.nist.gov/cuu/Units/binary.html
Source :
1. http://www.firebirdfaq.org/faq59/
2. http://www.firebirdsql.org/en/firebird-technical-specifications/