Design Question

[Bob Sneidar]

Does your stack auto-save anything at any time? If power fails during a save operation, there will be another stack file of the same name preceded by a tilde (~). Deleting the tilde will restore the prior version of the stack file.

Sometimes a power outage can damage the partition of the HDD. I would have UPS backups on all the systems you deem critical, and check these UPS systems every three months or replace them outright every three years (typical life expectancy of a lead acid battery).

Bob S


On Nov 18, 2020, at 2:20 AM, Lagi Pittas via use-livecode <use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>> wrote:

Hi,

I had 70 PS POS systems in the field and I saved the  list of items and
other info  after each addition it worked 99.9% of the time. But when it
failed (4 or 5  times a year) usually the same
customer (same hardware same windows 7 )I had to log in and copy a blank
livecode stack. In the end I had to save the info in the Sqlite database -
No problems since.

The stackfile never seemed to damage because of a power failure/outage or
anything - but had a greater chance if that was the case. The funny thing
was if you did switch the power off  off
without doing a proper shutdown there was no damage 99.9% of the time.
Never did get to the bottom of it.

Regards Lagi