Subject Re: [firebird-support] Max DB size?
Author Ann W. Harrison
Kjell Rilbe wrote:

> Thanks, both of you! And Helen! :-) Guess I should have two files in my
> DB, just to be on the safe side.
>
Don't bother ... use NTFS.


From
http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/Windows/XP/all/reskit/en-us/prkc_fil_tdrn.asp

Table 13.5 NTFS Size Limits

Description Limit
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)
Maximum volume size Theory: 264 clusters minus 1 cluster

Implementation: 256 terabytes minus 64 KB ( 232 clusters minus 1 cluster)
Files per volume 4,294,967,295 (232 minus 1 file)
Maximum Sizes on FAT32 Volumes

A FAT32 volume must have a minimum of 65,527 clusters. Windows XP
Professional can format FAT32 volumes up to 32 GB, but it can mount
larger FAT32 volumes created by other operating systems.


Table 13.6 lists FAT32 size limits.

Table 13.6 FAT32 Size Limits
Description Limit
Maximum file size 4 GB minus 1 byte (232 bytes minus 1 byte)
Maximum volume size 32 GB (implementation)
Files per volume 4,177,920
Maximum number of files and subfolders within a single folder 65,534
(The use of long file names can significantly reduce the number of
available files and subfolders within a folder.)


Regards,


Ann