Paul,
At 9.1 gigs your 12 million rows amount to near 1000 bytes per row.
Assuming you mean them *ALL* to be in ONE table, you have a problem with native VFP or FP because the limit is 2 GIGS per table. On the other hand, a near 1000 byte record can *usually* be broken down into several one-to-one relationships allowing them to "fit" (each) within 2 gigs.
*IF* however, the 12 million records are actually spread amongst several files and *NONE* of those files exceeds 2 gigs, GO RIGHT AHEAD! FP/VFP is GREAT for this. I used to have a FPD app with almost 30 GIGS spread amongst about 200 tables, and response was great ONLINE and batch processing was tolerable.
good luck,
Jim N
>I am considering a large 9.1GB 12 Million row VFP DB but am wondering if it can handle it any suggestions?
>
>
lagasse@infosys.bhs.org