I attempted to add records to a file, once the file reached ^07 it
would not let me add any additional records, all the extension files
and the dat file are at the same size (just a litte over 2 gig each).
I get no error message (I'm using Control Center Import function, that
may be why I get no error message) but it appears that it's at it's
maximum capcity. Any suggestions?

Pervasive's MAXIMUM file size is 64GB. However, each file cannot attain
this maximum.

Check the file's page size (BUTIL -STAT filename). The file can grow to
have 2^24 (~16M) pages. If each page is 1K, this is 16GB total, and you
will have 8 total extents (main file plus 7 extensions), and the file will
stop growing at this limit.

To get around this, rebuild the file (using the Rebuild Utility) and
change the page size from 1K to 4K. This offers the ability to get to 4K
* 16M = 64GB for the total file size, covering 32 extents.
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: March, 2004: See our web site for details!


Brandon DeArment wrote: