Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way to prevent data lost or data corruption?
Message
From
27/11/2006 16:26:47
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
 
To
27/11/2006 00:13:44
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172197
Message ID:
01172764
Views:
16
Rakesh,

Latest VFP can FORCE data to be written to disk rather than being kept in a machine's OS disk cache where it is obviously susceptable to PC freeze etc.

I can tell you for sure that since VFP6, data on My notebook has rarely been corrupted or lost, even when processing millions of records in one giant hit. Obviously a notebook battery is a defacto UPS ;-)

I have seen trouble in sites with flaky networks, or badly segmented ones so that vast slews of data traverse miles of cable looking for a target two feet away, or PCs running numerous apps with a pink dragon screensaver, fifteen Word instances, an obsolete app running in DOS mode, eight browser instances etc etc... if that's what you're facing, you need to expect crashes and possible data loss, even with the data on the same PC.

The beauty of C/S and the reason why it is "an easy answer" for those whose resources can cover it is that it does protect data from some of these glitches. An unsupervised data entry clerk with the pink dragon screensaver may still see the same PC freezes, but she'll only lose the current entry and won't screw up everybody else as well. It can be an easy win if a room full of data entry clerks has been getting locked out by corruption every day without realizing that Julie's @#@#$$# screensaver is the cause of it all ;-)
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform