Subject RE: [firebird-support] Does Firebird need "compact" process
Author Chris Thornberry

I did some additional research and found the following out for NTFS Volumes:

Maximum file size
Theory: 16 exabytes minus 1 KB (264 bytes minus 1 KB)
Implementation: 16 terabytes minus 64 KB (244 bytes minus 64 KB)

Now the following is true for FAT16 and FAT32:

Description Limit
Maximum file size
4 GB minus 1 byte (232 bytes minus 1 byte)

The entire page can be found at:

As an MCSE I would professionally recommend that if you have the option to
use NTFS that you should use it for its additional speed and security.

Hope that helps.


-----Original Message-----
From: Tim [mailto:tim@...]
Sent: Wednesday, August 04, 2004 7:03 AM
Subject: Re: [firebird-support] Does Firebird need "compact" process

>Do you mean a table size limit or database size limit?
>Databases are pretty much unlimited in size.
>With regards,
>Martijn Tonies

To clarify what Martijn says : the database size is limited by the
operating system and the size of your hard drives.

You can make Firebird have several data files, spread across different
drives, if you need to.

Any single file size is limited by the operating system. On Windows, the
maximum file size is 4 GB. So the limit on a Firebird Database file running
on Windows is 4 GB per file.

Yes, I know. It was confusing for me too, when I heard it the first time
... :-)



Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (
Version: 7.0.262 / Virus Database: 264.2.0 - Release Date: 02/08/2004

[Non-text portions of this message have been removed]

Yahoo! Groups Links