Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select Optimisation changes under VFP8?
Message
De
03/06/2003 12:34:41
 
 
À
03/06/2003 12:21:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00795674
Message ID:
00795766
Vues:
30
>The query is conducted on a cursor without an index. I will attempt to produce a replicable example.
>

Without an index, VFP will read every record. That would be true for all versions of VFP.

>In simple cases, my original post was wrong - the example given is identical under VFP6-7. All this does raise the question, though, why is the logic processing of an SQL Select command so much more inefficient than an IF command?
>

What do you mean by this? Do you have an example?
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform