Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FPT file 2GB Limit? A final answer?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00562711
Message ID:
00562785
Vues:
18
>Everyone,
>
>I just hit the 2GB limit on an .FPT file resulting in 'space exceeded' type error (forget exact message). The associated .DBF is 724KB.
>
>Reviewing the thread below reveals serious debate among industry heavyweights regarding the 2gb limit but I couldnt glean a final answer.
>
>http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~?2,15,520675
>
>VFP 7 Help under "Memo Field Type" states "Memo fields are limited only by the amount of available disk space."
>
>So, a final yes/no/workaround regarding this limitation would be greatly appreciated...

Either way you look at it you are flirting with disaster if your memos are that large. If you have a dbf, fpt or cdx over 2 gig you should consider either redisigning your schema to scale better or use another data engine that doesn't have the size limitation of a dbf/fpt structure, IMO.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform