Subscribe Bookmark RSS Feed

for each row locks up JMP for a couple of minutes

alex

Community Trekker

Joined:

Jun 23, 2011

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 )
)
);
2 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

You'll probably get better performance with this:

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

Community Trekker

Joined:

Jun 23, 2011

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