Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large Database
Message
From
01/08/1997 00:32:59
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00042602
Message ID:
00042734
Views:
35
> I am considering a large 9.1GB 12 Million row VFP DB but am wondering > if it > can handle it any suggestions? As mentioned in other responses, VFP can only handle 2Gb/table. But you may have the option of splitting this table into, say, 9 x 1Gb tables. In this case, your SELECT statements would be quite a bit more complex, but they would work. Same thing with just about everything else you want to do. Val Matison had an article in a FoxPro Advisor earlier this year (I think) about just this type of thing. It made for good reading. Of course, I'm not saying that this this the best option. I'm just saying that it is another option you might want to consider. I'd likely also go for the back-end when considering tables this size. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Previous
Reply
Map
View

Click here to load this message in the networking platform