Subject RE: [firebird-support] Questions about FB file size limits
Author Johan van Zyl
Hi
OK, On Linux, 32-bit file I/O
it's 2GB and 64-bit file I/O, a few terabytes.
Which Linux is 32 bit and which is 64 bit
Thx
Johan
-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 30 August 2004 23:53
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Questions about FB file size limits


Hi,

At August 30, 2004, 18:15, Chad Z. Hower aka Kudzu wrote:


> :: Then it's not an OS limitation, but a FB limitation. And, an error in
> :: Helen's book, since she mentioned the limitation for external file
> :: size on NTFS is 4GB. But, I'll not hold her accountable, since it

> What is the limit on the DB itself?

Whatever the file and operating systems permit. With NTFS, it's
64-bit file I/O, but apparently it's really 48-bit I/O, basically a
few terabytes. With FAT32 on Win2000 and WinXP(I don't know about
Win95 and Win98), it's supposed to be 4GB. On Linux, 32-bit file I/O
it's 2GB and 64-bit file I/O, a few terabytes. With a Windows NTFS
and Linux 64-bit file I/O, you might have a greater chance to max out
the volume space than the file system limit. But, even with the
32-bit file I/O, you can have multi-file databases, which will give a
larger database than 2 or 4 GB.

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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 2004/08/27


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