This seems like a pretty elementary question but does the structure of
how an expression is set up have any significant effect on performance?
When writing expressions, I tend to write out all words and align/box
items in a consistent format that makes it easy for others to read as in
the first example below. That includes me 6 months later. We are doing
more wireless connections and some concern has popped up that the extra
spaces/letters would effect performance speed as simply more info to
process. As time has gone by my EEPs have gone from simple 20 liners to
over some with well over 300 lines as we put more controls in. Have not
seen any difference on the LAN, but the wireless field laptops are not
the fastest machines. Using latest V8 and doing a complete jump to v9 in
the next week.
SELECT +
Item1, Item2, ThirdThing, NumberFour +
INTO +
aItem1 INDICATOR a1, +
aItem2 INDICATOR a2, +
aThirdThing INDICATOR a3, +
aNumberFour INDICATOR a4
FROM Z_MHA_Summary WHERE ZID = (.vZID)
Compared to
SEL Item1, Item2, ThirdThing, NumberFour INTO +
aItem1 IND a1, +
aItem2 IND a2, +
aThirdThing IND a3, +
aNumberFour IND a4
FROM Z_MHA_Summary WHERE ZID = (.vZID)
Tom Frederick
Jacksonville, IL
