Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: ed hardy
  Where is ed hardy?
 new york city
 New York - United States
 ed hardy
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Database, Table and CDX Corruption Issues
Thread ID: 107553 Message ID: 114860 # Views: 20 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Friday, December 01, 2006 6:41:51 PM         
   


I'm wary due to my dBase experiences. Maybe I shouldn't be so wary, but my approach evolved from my dBase era, finding a string of binary zeroes slashing through my dbf tables after power disruptions.

Currently, I have applications running for about eight years in a bad power environments, with few if any problems related to file corruption.

select * from customers into cursor x
use in customers
*...process x...
use customers
*...update customers...
use
use in x

Essentially I minimize the existence of open tables.

Server loads are never heavy in this small business environment, so I can open and close a table in at least 1/200th of a second, with confidence that data is stored to disk.

ENTIRE THREAD

Database, Table and CDX Corruption Issues Posted by Pete Sass @ 9/21/2006 12:31:05 AM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 9/21/2006 2:34:37 AM
RE: Database, Table and CDX Corruption Issues Posted by Emerson Reed @ 9/21/2006 4:02:41 PM
RE: Database, Table and CDX Corruption Issues Posted by JLW Wade @ 9/22/2006 10:22:22 PM
RE: Database, Table and CDX Corruption Issues Posted by ed hardy @ 12/5/2006 8:51:45 PM
RE: Database, Table and CDX Corruption Issues Posted by ed hardy @ 12/1/2006 6:41:51 PM
RE: Database, Table and CDX Corruption Issues Posted by Pete Sass @ 12/1/2006 6:51:42 PM
RE: Database, Table and CDX Corruption Issues Posted by Terry Parkinson @ 7/11/2007 4:31:50 PM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 7/11/2007 9:50:09 PM
RE: Database, Table and CDX Corruption Issues Posted by Terry Parkinson @ 7/12/2007 5:01:20 PM
RE: Database, Table and CDX Corruption Issues Posted by Riche Evardo @ 7/11/2007 8:14:00 AM
RE: Database, Table and CDX Corruption Issues Posted by TabzSki Cubita @ 10/25/2007 11:27:02 AM
RE: Database, Table and CDX Corruption Issues Posted by Rudy Hendrawan @ 12/6/2007 7:24:49 AM
RE: Database, Table and CDX Corruption Issues Posted by Ken Murphy @ 12/6/2007 12:31:10 PM
RE: Database, Table and CDX Corruption Issues Posted by Andrea Mariottini @ 12/6/2007 3:00:51 PM
RE: Database, Table and CDX Corruption Issues Posted by Stoycho Stoychev @ 1/24/2008 6:11:10 PM
RE: Database, Table and CDX Corruption Issues Posted by suhas hegde @ 12/6/2007 3:02:19 PM