Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which is faster?
Message
De
26/03/2000 04:00:21
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00350395
Message ID:
00350503
Vues:
25
Steve,

>I found out that the SQL SELECT is much faster than the SET FILTER in my testing today.

Watch out with this conclusion. It heavely depends on the selectivity of the query. If SQL is used to filter out a small set out of a large table, SQL is the clear winner here. However if you want to filter out only a small percentage of the (large) table SQL isn't worth the cost: use a SET FILTER instead.

Walter,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform