Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
If you code like this.... you might be a crappy coder
Message
De
26/05/2021 18:49:55
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
If you code like this.... you might be a crappy coder
Divers
Thread ID:
01680754
Message ID:
01680754
Vues:
94
select subs_var_select
set filter to ordnmb=m.ordlin.ordnmb and lnline=m.ordlin.lnline
go top
wRepriceStones = .T.
nStyle_Stone_Price=0
nOrdLin_Var_Price = 0
nDiamValu = 0
nClrValu = 0
nProtected = 0
scan
vs
wRepriceStones = .T.
store 0 to nStyle_Stone_Price, nOrdLin_Var_Price, nDiamValu, nClrValu, nProtected
SELECT subs_var_select
SCAN FOR ordnmb=m.ordlin.ordnmb AND lnline=m.ordlin.lnline
The second batch of code takes less time to execute and less time to step through in the debugger. It's easier to understand. These are facts, not opinion. A set filter, then a go top is wasteful. Go top is not going to respect the filter, even if it is optimized. Scan does a go top by default.

I write it the second way and have done so for many years, while I see things written the first way far too often. It's not my fault there are programmers who can't tell the difference. They keep holding development back and all the boot-camp wannabees are not improving things.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform