Subject | Re: Questions about FB file size limits |
---|---|
Author | Peter M. Jagielski |
Post date | 2004-08-27T14:08:51Z |
Paul,
Thanks for responding.
confusing. P. 946 says that the max *db* size is theoretically 7TB.
I take this to mean, truly, the max size, assuming the hardware/OS
platform supports it. But then she says the max *file* size is
"Depends on the file system...Older NTFS and ext3 are usually 4GB."
It sounds to me like I *can* have a 16G .FDB file under WinXP/NTFS.
I'll try breaking up the text file into 1G chunks and see how that
goes. At this size, I'm looking at ~1M recs/files, which is quite a
bit more than Helen's recommended 10k recs/transaction.
Hmm...any way to turn off transaction processing, like SELECT..NO
TRANSACTION?
Thanks for responding.
>> It doesn't quite say that the max db file size is 4GB under NTFS.I emailed Helen about this, because at least to me, it's a bit
confusing. P. 946 says that the max *db* size is theoretically 7TB.
I take this to mean, truly, the max size, assuming the hardware/OS
platform supports it. But then she says the max *file* size is
"Depends on the file system...Older NTFS and ext3 are usually 4GB."
It sounds to me like I *can* have a 16G .FDB file under WinXP/NTFS.
>> NTFS itself allows files up to 2TB, although not all MS O/SI assume that's true as my 16.6G text file *does* exist :)
> will support files that large.
I'll try breaking up the text file into 1G chunks and see how that
goes. At this size, I'm looking at ~1M recs/files, which is quite a
bit more than Helen's recommended 10k recs/transaction.
Hmm...any way to turn off transaction processing, like SELECT..NO
TRANSACTION?