Walter Meester
HoogkarspelPays-Bas
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Mike,
>CDX bloat or no, and reindex speed aside, if the cdx header gets corrupted, you cannot reindex. So why try to use reindex? I just tried a reindex on a million records which took 13 seconds. There are three tags, field1, field2 and
field3. The 3 index on commands took 11 seconds.
For me, REINDEX has the advantage over INDEX ON that I don't have to re-set the relations in the database container. In an event of CDX header corruption, (which IMO opinion is less frequent than in FOX 2.x times) your can take a copy of an empty CDX file, place it over the corrupt one and then reindex.
Walter,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement