Subject Re: [firebird-support] Questions about FB file size limits
Author Paul Reeves
On Friday 27 August 2004 15:19, Peter M. Jagielski wrote:
> I have Helen's Firebird book (HIGHLY RECOMMENDED!), and one of her
> appendixes (p. 946,947) states that the max DB file size under NTFS is
> 4GB.

It doesn't quite say that the max db file size is 4GB under NTFS. In fact
the max file size is O/S and File system dependant, up to a limit of 64
bits. So, to put it another way, Firebird is good to write files up to
2^63 bytes in size, and is only limited by the O/S and filesystem it is
running on. NTFS itself allows files up to 2TB, although not all MS O/S
will support files that large. In reality you are most likely to hit the
h/w limit of disc space before you hit one of the software limits.

> Also, the max size on a external file (NTFS) is 4GB.

That doesn't sound right to me. It would mean that we are still using 32
bit file addressing for external files. Considering the grief we had from
32 bit file pointers for the database I would have hoped that 64 bit file
i/o had been implemented across the board.

> Anyway, it would appear that I have exceeded these limits. What to
> do? Break up the external file into smaller (<4GB) files?

Yep. I can't say off-hand how small to make the files, but maybe you
should start with around 1GB per file.

Paul Reeves
Supporting users of Firebird and InterBase