Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's up w/2GB Table Limit?
Message
From
26/08/1999 08:21:24
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00256969
Message ID:
00257813
Views:
21
>
>There's nothing to prevent you from vertically or horizontally partitioning your tables, and if you truly need large files, you can move your data to a backend product like SQL Server or Oracle and continue to access it from your VFP application using SPT or remote views; now the limitation that you're stuck with is probably no more than 2G records/table. I haven't tried (I don't have) a table in a backend with >2G records, so this limit might not exist.
>
>You might want to look at some of the projects where people have used VFP for data warehousing; at least at one time, Val Matison of Matison Consulting in Toronto did a project involving data warehousing with native VFP tables that circumvented the limits by using vertical partitioning of data sets.
>

That was the Chunnel and was previously documented in FoxPro Advisor.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform