Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: VFP7 SP1 REINDEX no longer removes BLOAT from .CDX
Message
 
À
03/05/2002 08:11:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00652071
Message ID:
00652364
Vues:
30
Hi Jim,

>>All this adds up to something possibly being seriously amiss in the most fundamental area of VFP.<<

What had changed is the algorithm that handles an index node when a node is filled. Previously, VFP created a new node and continued writing there. Now VFP splits the existing node into two nodes. This results in a larger number of half-full nodes and an increased size between 0% and a little less than 100% compared to the previous index size. The exact increase depends on the order in which records are added to the index. The biggest increase in size occurs when data was ordered, which is why REINDEX has such an impact.

The new behavior has negative influence on the size of CDX files and performance. But it doesn't have any negative impact on stability and certainly does not cause data corruption. In fact, SP 1 fixes several bugs that caused index corruption and most likely the current behavior is the result of a bug fix.

In any case, this bug has been discussed on the CompuServe forum several times and in the past I have posted there more detailled explanations of what is going on.

Christof
--
Christof
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform