3248_en-US

liliconcom

for each row locks up JMP for a couple of minutesHi 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 )
)
);Re: for each row locks up JMP for a couple of minutesyes, I got much better performance. that's an understatement actually Re: for each row locks up JMP for a couple of minutesYou'll probably get better performance with this:

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