Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's up w/2GB Table Limit?
Message
De
26/08/1999 08:26:06
 
 
À
26/08/1999 08:21:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00256969
Message ID:
00257821
Vues:
25
>>
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform