I think the file size thould not be a problem for NTFS, if you can believe
what Microsoft says:


File Systems

FAT and HPFS both have internal limits of 4 GB due to the fact that they use
32-bit fields to store file sizes. NTFS uses 64-bit fields for all sizes,
permitting its data structures to handle volumes up to 2^64 bytes (16
exabytes or 18,446,744,073,709,551,616 bytes).

This value is the theoretical limit for the NTFS file system. Practical
limits having to do with the maximum allowable partition size described
above limit the size of an NTFS partition to approximately 2 terabytes.
Because the 32-bit fields of the partition table refer to the number of
sectors in the partition, disks with larger sector sizes translate into
larger permissible partition sizes. Currently Windows NT supports sector
sizes up to 4 Kilobytes. With 4KB sectors, Windows NT can support a 16
terabyte partition. As new hardware or software schemes become available,
NTFS will be able to handle substantially larger volume sizes.

http://support.microsoft.com/support/kb/articles/Q114/8/41.ASP


I remember that even from the NT 4 days, this was possible, however we are
talking here about the max file size not partition size, which they are not
stating here in the article, NTFS from win 2k and up can definitely do it,
we have created files before of 8gb+.

Just thought this might help.

Anyways maybe other Interbase gurus can answer this one but I remember
someone telling me sometime ago that you can set interbase up to
automatically split files at 2gb, and I think this is the desired method
anyways, I'm not 100% sure.



_____

From: Bogdan Mugerli [mailto:mugerlibogdan@...]
Sent: Monday, November 10, 2003 10:32 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Max file size

Hi

We have a large datawarehouse database Firebird 1.03 running on WIN 2000
SERVER. (NTFS)
It is beeing filled every night from data of an old Cobol application.
It ran smooth for cca 5 month, then we noticed the differences between Cobol
data and data in our database.

Database is beeing updated thru triggers in the following way:
there a two tables - first collects all data from Cobol database ( date
from - date to)
the second is dimension table which is updated by triggers of the first
table.
All is done in single transaction

The problems began, so it seems, when we crossed the 4G limit.

Is it possible that crossing 4G limit is cousing the inconsistencies.

( we have 2 other installations with smaller databases that are running with
no problems)

Regards
Bogdan Mugerli





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=258297.4155332.5363524.4049140/D=egroupweb/S=17051153
86:HM/A=1683962/R=0/SIG=11j2ftep6/*http:/www.techsmith.com/rdr/ban/syah/defa
ult.asp> click here


<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=967475432>

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



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


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