Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi John,
You don't have to remove the delete records inmediately. When after a while large amounts of deleted records exists, then issue a pack.
When recycling records you might be better of with a index constructed with:
INDEX ON .T. FOR DELETED() TAG Del
This one never gets used by rushmore and is smaller than the DELETED() TAG because it only contains nodes for actual deleted records.
You can simply search for a deleted record with:
SEEK(.t.,CYourAlias,"Del")
Walter,
>Hi Walter,
>
>If you are not recycling records on a networkable application (I use a deleted() tag to do this) when do you remove the deleted records? My applications are all end user types rather than corp type. My selects are slow and I think that the deleted tag may be the problem...
>
>Thanks
>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only