Subject | RE: [firebird-support] FB1.5 Max. file size, max records |
---|---|
Author | Leyne, Sean |
Post date | 2007-06-06T15:53:49Z |
> Do you know what is the max file size for a FB 1.5.?FB 1.5 supports 64 bit file IO, accordingly the maximum file size is
based on the limit of the file system.
So, if you are running FAT the limit is 2GB, if you are running FAT32
the limit is 4GB, if you are running NTFS the limit is several TERAbytes
(the limit is different between Win NT and Win2000).
> Do you know what is the max records for a table?There is no simple answer to this question due to the way that records
are stored in the database. The best answer is based on the following
formula:
Maximum Records = 40 GB / average record size
(Where average record size does not include blobs which are larger than
page size)
This limit was completely removed in FB v2.0
Sean