Hello,

Is it possible to have one DDF file with size larger than 2GB using
Pervasive 8.10 (SP1) and Linux? Pervasive engine just creates additional
segments (above 2GB) and claims that it must do it "due to platform
limitations" which is obviously false (current limit for single file is
2TB). There is no such effect on Novell NetWare or Windows.

Any suggestions?

--
Cezar Cichocki
CYBER Service

DDF, as in FILE.DDF? FIELD.DDF? These system tables are limited at no more
than 65535 records due to internal constraints, so I would never expect them
to get very large.

If your application uses DDF as the extension for user tables, then this can
get quite confusing. However, if this is the case, the engine does split
the table at the 2GB limit and creates ^01, ^02, ^03, etc. up to the maximum
file size.

The maximum file size is determined by the page size. If you do a BUTIL
-STAT on the file to see the page size, multiple the page size by 16 million
(the max number of pages in a file) to get the maximum file size. Thus, a
512-byte page will have a maximum file size of 8GB, and a 4K page can get to
be 64GB (31 extensions plus a base file).

This 2GB extent size was selected for best cross-platform compatibility.
Since the Pervasive.SQL engine can store data on just about ANY networked
operating system, they selected the smallest size supported across ALL
platforms -- 2GB. Since the Pervasive code is identical on all platforms,
this selection is used on all engines, ensuring that data files will be
compatible across all engines.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


Cezar Cichocki wrote:

I have to agree with Bill about the contents of the DDF files being
limitted to 64K records. The largest I have seen was a couple of MB.

I would have to say that the ultimate file size depends on which file
system is used. Not all file systems in use do support files that
large, e.g. EXT2 (admittedly in declining popularity), Novell Native
(faster on writes than NSS) , FAT16 or FAT32 (hey you could)...

As Bill points out the file segment sizes were chosen for maximum
compatibility when hardly any file systems supported >2GB.

He is also correct about the ultimate file size being 2^24 * page
size.

Leonard

On Wed, 30 Jun 2004 11:19:37 +0000 (UTC), Cezar Cichocki
<cezar (AT) gruby (DOT) cs.net.pl> wrote: