Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question about deletes
Message
De
18/02/2000 02:07:49
Walter Meester
HoogkarspelPays-Bas
 
 
À
17/02/2000 20:52:35
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00333472
Message ID:
00333957
Vues:
19
Cindy,

>Why do you feel it is necessary to permanently get rid of records? Are your tables that large that you MUST re-use records?
>
>I've seen too many ng posts where the motivation behind this was a misunderstanding of the concept and proper use of a primary key.

From a technical point of view it is possible that the VFP-team enhances the DBF tables in such manner that deleted records are reused, so the need for packing tables would be greatly reduced. In general we would like to get rid of deleted records because they take up space, and reqiures new records to be appended at the end of the file, so increasing the risk of defragmentation of tables. So I'd say that recycling records is generally good for performance and uptime reasons.

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

Click here to load this message in the networking platform