Subject | Re: [firebird-support] Firebird 2 multiple DB files? |
---|---|
Author | Anderson Farias |
Post date | 2008-03-18T14:22:44Z |
Hi Helen,
note says:
[FROM FB 1.0 RELEASE NOTES]
Large Database File Support
(Sean Leyne, David Trudgett)
The logical database can comprise a primary file and numerous secondary
files (the standing record for a single FB/IB database is 980GB!). However,
this enhancement concerns the size of a single physical database file. The
maximum file size limit involves three separate factors:
* the implementation (coding) of the FB/IB engine I/O functions <=== HERE
* operating system support for 64-bit file operations
* filesystem limits on file size
Engine support for 64-bit file I/O
All Firebird/IB versions prior to FB v1.0 (including IB v6.0) used both
32-bit API/OS calls and 32-bit (integer) file pointer structures. The
engine's capability was thus designed to handle files with a maximum file
size of 4Gb. In the Unix code the file pointer structures were defined as
signed
integers, thus limiting Unix and Linux implementations to file sizes of 2Gb.
[END]
FB 1.0 introduced 64bit I/O. To me your statement is not consistent with
what is written to the FB 1.0 Relase Notes. More on how this FB
implementation was done for Windows/Linux can be find at this release notes.
Also, I've had problems on the past using IB6 and db files over 2Gb on a
Linux (with Ext3, thus supporting files larger than 2GB) and moving to FB
1.0 with 64bit I/O fixed!
Regards,
Anderson Farias
> True only if the database partition is FAT32 or NTFS4. (If OS wasThat is a quite interesting statement Helen, here is what FB 1.0 release
> upgraded originally from NT 4, existing partitions are not "upgraded" to
> NTFS 5)
note says:
[FROM FB 1.0 RELEASE NOTES]
Large Database File Support
(Sean Leyne, David Trudgett)
The logical database can comprise a primary file and numerous secondary
files (the standing record for a single FB/IB database is 980GB!). However,
this enhancement concerns the size of a single physical database file. The
maximum file size limit involves three separate factors:
* the implementation (coding) of the FB/IB engine I/O functions <=== HERE
* operating system support for 64-bit file operations
* filesystem limits on file size
Engine support for 64-bit file I/O
All Firebird/IB versions prior to FB v1.0 (including IB v6.0) used both
32-bit API/OS calls and 32-bit (integer) file pointer structures. The
engine's capability was thus designed to handle files with a maximum file
size of 4Gb. In the Unix code the file pointer structures were defined as
signed
integers, thus limiting Unix and Linux implementations to file sizes of 2Gb.
[END]
FB 1.0 introduced 64bit I/O. To me your statement is not consistent with
what is written to the FB 1.0 Relase Notes. More on how this FB
implementation was done for Windows/Linux can be find at this release notes.
Also, I've had problems on the past using IB6 and db files over 2Gb on a
Linux (with Ext3, thus supporting files larger than 2GB) and moving to FB
1.0 with 64bit I/O fixed!
Regards,
Anderson Farias