Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No (more?) bloat with REINDEX command
Message
De
25/06/2001 14:43:10
 
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:
00523146
Vues:
24
>Jim,
>
>With SP5 I just used REINDEX on a table with 214,319 records with 15 tags and I get 15 distinct sets of .....GENERATING ......INDEXING messages on the status bar. It would appear that there must of been 15 different reads of the dbf to create the cdx file. I agree that the bloat issue seems to be a obsolete problem as my cdx file went from 20762kb to 13161kb and is holding there after 5 REINDEX commands.
>
>How are you determineing that only one read pass of the dbf is necessary?


That was confirmed by MS when SP3 shipped.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform