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/