You will have to face the 2 Gig table limitation. However, you can split the tables either horizontally or vertically. The EuroTunnel runs on FoxPro has handles several hundred megabytes of data.
>We are looking for benchmarks documneted for VFP 6.0/7.0. By Microsoft or any third party source. We would also like to know if anyone has large scale applications operating on tables greater than 40 million records. Today a customer requested if VFP 6.0/7.0 could handle 1000 transactions per minute. Also, if VFP 6.0/7.0 could hanlde file sizes of 40 million records. The most our applications have handled very well, is in the 10 million record range in a real working envirnoment.
>
>Thanks,
>
>Alfred M. Menendez
>CEO
>Fermen Corporation
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer