Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Wishlist: SET RECYCLE on and Index on Deleted records
All,
To Enhance concurrency and decrease the need to pack tables, the following might be a welcome enhancement:
VFP should have the possibility of natively recycle deleted records, so the need of packing tables is reduced. Then tables won't grow larger and larger. NOTE: this only applies to tables, not memo files.
This switch might be set with a
SET RECYCLE ON command.
Every INSERT or APPEND command would make VFP search for a deleted record, fill the contents of the table and clear the deleted mark of the table.
This is now virtually impossible: though you could program this approach for native tables, if you make use of VIEWS, you're not able the recycle recrords in the underlying table.
To accomplish this matter, we also must have a possibility to quickly lookup deleted records. This could be done with an index like:
INDEX ON .T. FOR DELETED()
To hide or emphasize this special index for the user it might be handy to make this index with the following INDEX command:
INDEX ON DELETEDRECORDS
Walter,
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement