>Hello Hugo,
>Yes, you are right the cdx file size is much greater than the dbf file size.
> Can you please tell me:
>*****************
>you mentioned:
> but it seems to me that your CDX is overgrown, so I would try to recreate it.
>
>What happens if i recreate my .cdx file again.
>
>Do i lose all the records which are in the table.
>**********************************************************
>
>Please Let me know.
>
>My job is really at stake this one is using by my client they are in another state. I am not tracking there database regularly.
>But they tell always that the date and time both are getting modified each time after uploading the ocr content of each page to the table.
>
>Thank you very much.
Our experience is that we do not lose any records because of the re-indexing process to fix this problem. We lost records prior to this proccess, for when the index is corrupted in this way, it always appends the record in the same place, that is, it always overwrites in the same position over and over again.
I would make a copy of all the files, just in case, and then recreate the indexes, you can do it manually with INDEX ON.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges