Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the effect of buffering on Tables?
Message
 
À
02/03/2002 17:56:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00627381
Message ID:
00627496
Vues:
14
>>If using a free table I turn on optimistic table buffering and append blank what happens at that point to the table header? I am asking because I want to know if using buffering makes the table more prone to data corruption. Most of my users are on low end peer to peer networks and I seem to be experiencing much more data corruption since moving to VFP.
>
>I didn't notice more data corruption with VFP, than with FoxPro.
>
>Be sure to issue a FLUSH after each TableUpdate() - this will not ensure zero corruption, but I think it helps a lot.
>
>Hilmar.

Hilmar,
There is a bug using buffer mode #3 that leads to table corruption. What you want to use is mode #5, but do your TABLEUPDATE after each row change and set the parameters to treat the rows singlely.
JLK
Nebraska Dept of Revenue
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform