>Hi..
>
>Please help me, I'm facing a problem of database index corruption. I'm using free tables and daily we add 15000+ records in a table.
>
>How can I check that weather index files (.CDX) is corrupted/damaged of nor ?
>
>Ravi,
It should be quite slow to check for corruption. I suggest you simply try to avoid corruption in the first place:
1) Use FLUSH every time you make changes to a record, or add a new record. If you use buffering, this would be after the TableUpdate().
2) Make sure your OS doesn't use a write-cache.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)