Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizable expressions
Message
De
22/03/1999 13:46:30
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00200386
Message ID:
00200594
Vues:
9
Christof,

>1. LIST FOR id = 'X' AND DELETED()

>2. LIST FOR DELETED() AND id = 'X'


>When you have an index on DELETED() and ID, both should take the same time. If you don't have an index, the second one should be faster, because only in 50 cases the expression ID="X" has to be evaluated.

From the theory you're right, but since the most time would be spend by getting the actual records into memory, in practice there would be no significant difference as it don't take much time to evaluate both of the expressions.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform