Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the effect of buffering on Tables?
Message
 
To
02/03/2002 17:56:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00627381
Message ID:
00627496
Views:
15
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform