locked
Is VFP more susceptible to data corruption? RRS feed

  • Question

  • Hi generous friends,

    Two of my clients are engaged in fabrication. Voltage fluctuation is high.

    Hence, if they use my program developed in VFP tables are corrupted oftenly comparatively to other software like Tally.

    Kindly comment on it.

    Thank you all.

    Tuesday, December 31, 2013 10:12 AM
    Answerer

Answers

  • Hi Ravindra

    VFP is more susceptible than say SQL server however you can do a few things that may help the issue. Make sure you have turned off HDD disk caching on both the server and local computers. Using Terminal Server may help over using a standard network. Not sure if a UPS will help with voltage regulation. Hope those suggestions help.


    Mike z

    • Proposed as answer by Naomi N Wednesday, January 1, 2014 12:15 AM
    • Marked as answer by Leo (Apple) Yang Tuesday, January 7, 2014 7:16 AM
    Wednesday, January 1, 2014 12:08 AM

All replies

  • Could it be your programming? Assuming you did not program Tally. How does it compare to other sites using your software?

    Suggest they fit a voltage regulator or a separate power cable and see if that solves the problems. 

    When writing data to disk there are several reads and writes taking place in low level code - so the voltage surges could be the problem. It could be that Tally handles data differently and holds it in memory and so does fewer disk read/writes - hence less corruption. Or of course it could be the other way round if the surges are effecting memory more than disk writes.


    The English Bob

    • Proposed as answer by Naomi N Wednesday, January 1, 2014 12:14 AM
    Tuesday, December 31, 2013 10:29 AM
    Answerer
  • Hi Ravindra

    VFP is more susceptible than say SQL server however you can do a few things that may help the issue. Make sure you have turned off HDD disk caching on both the server and local computers. Using Terminal Server may help over using a standard network. Not sure if a UPS will help with voltage regulation. Hope those suggestions help.


    Mike z

    • Proposed as answer by Naomi N Wednesday, January 1, 2014 12:15 AM
    • Marked as answer by Leo (Apple) Yang Tuesday, January 7, 2014 7:16 AM
    Wednesday, January 1, 2014 12:08 AM
  • Both on-line and off-line UPS must help. Of course, you have to protect the whole infrastructure (PCs + network + servers). Another alternative is to protect servers only and redesign your app to client-server architecture.

    Wednesday, January 1, 2014 2:15 PM
  • What kind of data corruption are you experiencing? Do you have extraneous characters in data? Do you have files that can't be opened due to header and data not matching up?

    I agree with what people have said about doing something to address the power situation. Depending on what exactly the data problem is, another thing you might consider is some kind of real-time mirroring setup using database triggers.

    Kevin Clark

    Thursday, January 2, 2014 3:11 PM
  • Use FLUSH command more often and disable the HDD cache.
    Friday, January 3, 2014 1:09 PM
  • My first question was "Is VFP more susceptible than what?" You're asking us to compare VFP to something but not specifying what that is.

    However, there are some things you can do to minimize problems

    - Never use a table directly. Always use a View

    - Use FLUSH after every update

    - UPS battery backups on all the servers, workstations, and network equipment


    Craig Berntson
    MCSD, Visual C# MVP
    INETA Community Speaker
    www.craigberntson.com

    Friday, January 3, 2014 3:14 PM