>Hi,
>
>I have a technical query:
>
>I have a database of 200,000 records that I have imported into a new (identical) structure with 36 indexes in the CDX.
>
>I would like to know if Foxpro will have problem with index tree balancing.
>
>If so will recreating the index correct this.
>
>The main question is should we re-create the indexes using INDEX ON from scratch OR REINDEX. The more detailed the better.
>
>Any ideas,
Hi there,
First of all let me tell you that the number of records you have specified above is not of a major thing to handle for VFP. I have an application which has 2 million records working with VFP without any major index hurdles.
In case of index curruption, I would advise you to use REINDEX command to reindex all the tags OR remove CDX file and again INDEX ON each for each tag.
As far as the speed is concerned REINDEX will work a bit faster as it does everything in one go.
Bye
Jayesh
- Jayesh