Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Single Pass Reindexing
Message
From
10/05/2001 13:44:01
 
 
To
10/05/2001 11:16:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00505581
Message ID:
00505889
Views:
21
SNIP
>
>There are two problems:
>
>- CDX bloat. If you simply REINDEX, the new tags will be appended to the end of the CDX file. You need to DELETE TAG to remove the space, but then, REINDEX won't work.
>- REINDEX relies on the tag information stored in the header of the CDX. If this is corrupted, the index will be too or VFP won't be able to read the information. In this case you may have to delete the CDX to build the indeces.

Craig,

It would be useful to verify that the above is still true (listening, MS???).

I say this because the change that speeded up the reindex in the first place could also have taken all of the TAG info in at once and then used them from there. That could eliminate *voth* points above.

Sure would be nice to know if this is what was done.

Cheers,

JimN
Previous
Reply
Map
View

Click here to load this message in the networking platform