Which is the fastest statement to run...

technique

We all write code like this all the time so I'm looking for THE definitive answer in terms of performance.

In NAV2017+ which is the fastest statement:

1)
IF GLSetup.GET THEN
IF GLSetup.Fieldname THEN
DoSomething := TRUE;

or

2)
IF (GLSetup.GET) AND (GLSetup.Fieldname) THEN
DoSomething := TRUE;

The 2nd one is my preference and I think it is neater but want the one that executes fastest...

Slawek_Guzek

The first one will be a tiny bit faster, as in the first case second instruction is only executed if the first GET returns true, and in the second case both GET and test on GLSetup.Fieldname are always executed.

The second check IF GLSetup.Fieldname is much much much quicker that the first, to the point that the difference between 1st and 2nd might be unmeasurable.

If you prefer the 2nd form you might get caught some day if the 2nd check is also slow.

AK

No guesswork needed. Set both of the code snippets into a loop and count the time for x loops. I would bet the difference is negligible in any scenario since there is no real difference in what is done nor in what order it is done. It might very well be that the compiler produces the same code for both examples.
I would care for that if we would code in assembler and counting CPU cycles, but we have to worry more about what is going on on the SQL server side.

Slawek_Guzek

The first one will be a tiny bit faster, as in the first case second instruction is only executed if the first GET returns true, and in the second case both GET and test on GLSetup.Fieldname are always executed.

The second check IF GLSetup.Fieldname is much much much quicker that the first, to the point that the difference between 1st and 2nd might be unmeasurable.

If you prefer the 2nd form you might get caught some day if the 2nd check is also slow.