Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
AS Clause
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00409807
Message ID:
00409948
Vues:
28
>Hi George,
>My tests indicate that it is by about 2.5 times (roughly). Some of this may be attributable to something I found out back in FPW 2.6. I haven't tested to see if it still applies. Using variables rather than literals can (or at least used to) improve performance of a query. Since .T. is a literal, and you're removing it, this may also apply.

Variables are faster than literals?!? Wow! That surprises me.

>I also think statements like...WHERE table.logicalfield = .T. are redundant, and, therefore, unnecessary. So even if there was not a performance difference, I'd code it this way anyway.

I agree, sort of. <G> For 'if', 'for', 'while', i.e. VFP statements, I skip the operators on logicals. But for SQL I include it. Except for writing one SQL statement that can easily be converted to the back-end, I don't have another good reason for the discrepency. <G>
Bill Armbrecht
VFP MCP
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform