for each row locks up JMP for a couple of minutes

Question

Hi I'm running the 2 below loops in a table of 2000 rows and they lock up JMP 8 for a few minutes while running.
I've done similar in the past where I don't think this is the case.
Does this seem normal behavior?  If not, any suggestions as to what I'm doing wrong?
Thanks,
Alex

For Each Row( Row State() = Excluded State( 0 ) );

For Each Row(
	If( MonthFinish2 >= 201010 , 
	/*then*/		Row State() = Excluded State( 0 )
	, 
	/*else*/		Row State() = Excluded State( 1 )
	)
);

alex · Answer

yes, I got much better performance.  that's an understatement actually :)

pmroz · Answer

You'll probably get better performance with this:

dt << clear row states;
dt << select where((:MonthFinish2 >= 201010) << exclude << clear select;