Database consists of pages, and they are indexed using 32 bits.
Hence maximal theoretical db file size is
page_size * 4GB

Ivan

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, August 30, 2004 11:53 PM
Subject: Re: [firebird-support] Questions about FB file size limits


> Hi,
>
> At August 30, 2004, 18:15, Chad Z. Hower aka Kudzu wrote:
>
>
> > :: Then it's not an OS limitation, but a FB limitation. And, an error in
> > :: Helen's book, since she mentioned the limitation for external file
> > :: size on NTFS is 4GB. But, I'll not hold her accountable, since it
>
> > What is the limit on the DB itself?
>
> Whatever the file and operating systems permit. With NTFS, it's
> 64-bit file I/O, but apparently it's really 48-bit I/O, basically a
> few terabytes. With FAT32 on Win2000 and WinXP(I don't know about
> Win95 and Win98), it's supposed to be 4GB. On Linux, 32-bit file I/O
> it's 2GB and 64-bit file I/O, a few terabytes. With a Windows NTFS
> and Linux 64-bit file I/O, you might have a greater chance to max out
> the volume space than the file system limit. But, even with the
> 32-bit file I/O, you can have multi-file databases, which will give a
> larger database than 2 or 4 GB.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)