Re: Purchase 8.0 or want for 9.0?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Anders Altberg (x_pragma_at_telia.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 15:00:50 +0100

The limit also applioes to each of the three files that usually make up a
VFP table, The DBF for fixed length data, the attached FPT file for various
kinds of variablelength data such as Memo, Memo binaray and Blob. And the
attached CDX index file . Each one is limited to 2GB so a 'table' can go up
to 6GB. Or 4GB if the indexes don't count as data.
-Anders

"Gene Wirchenko" <genew@mail.ocis.net> wrote in message
news:pc68q0hsp2qcjt76uvhv35upb4lefugd0u@4ax.com...
> "Arcadefx" <Arcadefx@discussions.microsoft.com> wrote:
>
> [snip]
>
> >Anyone run into the 2GB database size limit? Are there work-a-rounds? I
> >may have mis-read the limitations of VFP, so set me straight if I did. :)
>
> You have, a bit.
>
> An *individual table* is limited to 2 GB. The .dbc is itself a
> table and is thus limited to 2 GB. The database may have tables that
> aggregate over 2 GB, say 1.5, 1.6, 1.8, and 1.2 GB. The limit applies
> to EACH table, not the total, so this example is quite possible.
>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.