IF IF or IF AND 1

[dbomrrsm]

Very quick question:

What would be more efficient:

IF var_a = var_b THEN
	IF var_c = 101 THEN

Do something......

	END IF;
END IF;

OR

IF var_a = var_b AND var_c = 101 THEN

Do something......

END IF;

Or would there be very little difference ?

TIA


[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Dagon]

The first one will fail if a != b and not test the second condition, so behaviourly they are the same.

As Santa Mufasa says, one test is worth a hundred expert opinions. Put them both in a loop which counts from 1 to a million and run a comparison. I think you will struggle to detect any difference at all.

 

[dbomrrsm]

Dagon

You were completely correct - a 100 million loop cycle took 87.8 seconds using IF IF and the same took 87.93 seconds for an IF AND.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]