BookmarkSubscribe
Choose Language Hide Translation Bar
alex
Community Trekker

for each row locks up JMP for a couple of minutes

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 )
)
);
0 Kudos
2 REPLIES 2
pmroz
Super User

Re: for each row locks up JMP for a couple of minutes

You'll probably get better performance with this:

dt << clear row states;
dt << select where((:MonthFinish2 >= 201010) << exclude << clear select;
0 Kudos
Highlighted
alex
Community Trekker

Re: for each row locks up JMP for a couple of minutes

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