Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No (more?) bloat with REINDEX command
Message
De
26/06/2001 09:39:14
Walter Meester
HoogkarspelPays-Bas
 
 
À
26/06/2001 09:27:41
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523073
Message ID:
00523540
Vues:
18
Hi mike,

>That's really clever. You'd build the indexes on an empty table. You'd still have to keep the code around. The same code could create the relations. So, unless that .PRG gets hosed (but with source safe that would be hard), there's
still no advantage to reindex.

I keep CDX files in a seperate dir. In an event of index corruption I copy the empty cdx over the old one and reindex. Deleted relations are manageble as well in some way (e.g. recalling records in the database) but keeping a copy of the empty CDX files is just comfortable enough for me.

I think its just a matter of taste. I see no real advantage of using one strategy over the other.

Walter,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform