Hi Bob,

>If you have never seen index corruption in 5 years in a Fox app then you are either VERY lucky or your definition of 'pounding' doesn't match mine.

I've got about 100 installations of software with hundreds of daily users troughout the country for about four or five years now. I've never had any call about index corruption with the exception of one guy that copy and paste DBFs without CDXs from one dir to another.

I might be lucky, however, much depends on how you do access your data. If you have buffering enabled and save your changes within transactions you've minimized the risks of dealing with corrupted data.

I agree that SQL is more robust, but if you take the right strategy this is not really a very strong argument (for most application types).


Walter,