In general, I have only seen index corruption only in the following circumstances:
- Power outage
- Hardware problem
- Operating system crash
- VFP crash on older operating systems
Simple VFP crashes don't seem to corrupt index files on Win NT, 2000, 2003 and XP, but may be I just got lucky. Regarding whether corrupt index files are always truncated to 0 bytes, I don't really have a definitive answer. My guess is that this is not always the case, but it's possible I'm wrong.
FoxWeb Support Team
support@foxweb.com email |
Sent by Joe Cosby on 02/17/2004 08:36:27 AM:
This is a general foxpro question, sorry if this is a little off-topic.
How much trouble have other people had with table indexes?
My experience has been that indexes do get trashed, but when this happens it is due to a failed write operation, and the index (.cdx or .idx file) is inevitably truncated to zero when this happens.
Has anybody here seen cases where the index becomes inaccurate, but it isn't truncated to zero bytes?
The reason I ask, the system I adopted has a process which reindexes tables regularly. Since in Foxpro this requires USE EXCLUSIVE, this is a real problem in a high-traffic, multi-user system.
I'm not sure how much sense it makes, if indexes don't become corrupt without being truncated then it is just a waste.