☐ cool new feature
☑ could help many users!
☑ removes a „bug“
☐ nice to have
☐ nobody needs it
Get rows where is extremely slow if the column is referenced with a varible (here i=5 )
dt = Open( "$SAMPLE_DATA/Wafer Stacked.jmp" );
t0=hptime();
i = 5;
dt << get rows where( As Column( dt, i ) == 10 );
(hptime()-t0)/1000000;instead of a direct reference like in
dt << get rows where( As Column( dt, 5 ) == 10 );My wishes:
- Is it possible to "fix this issue in the background"?
e.g. by a setting in the preferences:
"hereby I confirm that JMP is allows to pre-evaluate variables to speed up code execution - accepting that this could lead to unintended/unusual behavior"
(I am not good enough in JSL programming to predict all the collateral effects - would such a mode make sense?) - If fixing the issue in the background is not possible, could you please implement a warning function in JSL such that the user gets informed about the bad performance due to non-pre-evaluated variables. Then he can adjust the code,
with substitute
or Eval:
https://community.jmp.com/t5/Discussions/Should-you-Loop-through-a-data-table-or-use-Recode-or-use-G...
4 Comments