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:26:06
 
 
To
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:
00257821
Views:
24
>>
>>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.

Thanks, Craig.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform