The record count limit is over 4 billion records, which should not be a
problem, but there is a file size limit which is more likely in some
cases.
From the server console, enter "LOAD BUTIL -STAT filename" where the
ARCserve database file (the largest, I presume) is the file provided.
1) If you see that the file is 6.x format, the maximum file size is 4GB.
2) If you see that the file is 7.x format, the maximum (logical) file
size is between 8GB to 64GB. This will be accomplished by breaking the
logical file down to multiple 2GB physical files.
3) To determine actual maximum size, multiple the page size (reported by
the STAT call) by 2^24.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
See our web site for details!
> We have a dedicated server running NW 4.11/SP8a and
> ArcserveIT 6.61 SP2 with Btreive 7 as it's database.
> I understand the maximum number of records for this
> setup is 25 million. Also under NW4.11 the max file
> size is 4GB (no suballocation). Currently we are at
> 21 million records. CA cannot seem to verify the 25
> million number and I can't find any info on Pervasive's
> website.
> Will my dB stop at 25 million and refuse to insert more
> records?
> Thanks,
> DL Meade, CNE
> Systems Administrator
> www.fsb-ae.com
by