Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Are memo fields safe?
Message
De
01/03/2000 08:52:29
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00339561
Message ID:
00339704
Vues:
17
It's always been a crapshoot for me. The same application will corrupt with more or less frequency on different networks (notice how nobody uses the word LAN anymore?). Honestly, though, I haven't seen FPT or DBF corruption of any great severity since ... ohhhh ... FPD 2.6 running on a Novell 3.x network.

OTOH, @#&%#@@&# indexes............


>Just to clear the issue up, the thing that affects the likelihood of any file being damaged is the "window of vulnerability". That window the duration that the file is being written to. Because of how VFP stored memo data, an update usually takes longer than the same update to a dbf file. The longer it takes to update the larger the window of vulnerability and according to statistics the higher the incidence of damage.
>
>As John suggested VFP writes to the metadata tables internally, meaning there is no interpretation going on the execution is faster, thus reducing the window of vulnerability and the likelihood of damage.
>
>I have quite a few systems out there using memo fields and do not have problems with FPT fiel damage. OTOH, there are systems out there that do have FPT corruption problems. I can only surmize that I must be doing something differently than those systems do it.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform