Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing a View/SQL-Select
Message
De
21/11/2000 10:35:18
Walter Meester
HoogkarspelPays-Bas
 
 
À
21/11/2000 09:09:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00443643
Message ID:
00444130
Vues:
19
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
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform