Hi,

At August 20, 2004, 03:07, Dan Wilson wrote:

> On 8/20/2004 at 5:45 AM rithban wrote:

>> I've been told that the maximum size (on Windows) for a single-file
>> database on Interbase < v7.1 is 4GB.
>>
>> Is this still true for Firebird, or has that limit been eliminated?
>>
>> I'm using IB6 right now and hit the limit, and would prefer to stay OSS.
>>

> Firebird 1.5 and 1.5.1 support 64-bit file i/o on file systems
> like NTFS that support that.

It's been in place since Firebird 1.0 on Windows. And, with Linux, it
depends if the kernel supports 64-bit file I/O.

> Win2K and later are fine, provided you
> have formatted the drive as NTFS and not FAT-32. Under Win 95, 98,
> and ME IIRC you have a 2GB file size limit imposed by
> FAT-32.

Under FAT-32, the limit is 4GB. Under Linux 32-bit file I/O, it's
2GB.

> I'm not sure about NT4.

With NTFS, it's not a problem. Your more likely to hit the volume
limit than the max file size limit.

And, at the present time, there's a per table size limit that was
reported(some say 40GB and some say 80GB), but that limit will be
removed in Firebird 2.0.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)