Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PACK - what to expect?
Message
De
13/01/2003 12:58:40
 
 
À
13/01/2003 12:43:03
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00740999
Message ID:
00741074
Vues:
23
>>The behaviour observed does PARTIALLY make sense - why bother to change the table if there were no deleted records removed!?!
>
>But that would require additional work for VFP, to analyze if there are deleted records in the first place. Assuming that there will usually be deleted records, it seems much more efficient to do the PACK inconditionally.

It doesn't seem to be "additional" work... it appears to copy the table's undeleted records as per normal, then decides to quit IF it didn't encouner a deleted record along the way. So it just deletes the copy in that case (if it even wrote it in the first place (it may have fit in RAM)). Then it of course skips the REINDEX, but continues with the FPT read/analyze.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform