Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pros and Cons of SQL vs DBF
Message
De
03/08/2003 13:54:33
 
 
À
03/08/2003 11:26:26
Mike Smith
Doncaster Office Services
Oakville, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00816294
Message ID:
00816316
Vues:
17
Hi Mike,

on SQL you cannot RECALL DELETED records; SQL mark deleted records like empty space on file page, and it res-use part of this space automatically on internal garbage collection of file pages.

This is, normally, fast and little correlated to the number of record because the table isn't a table, but a b-tree clustered index.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform