3196_en-US

liliconcom

JSL Performance and Computed ColumnsHello all,

I have a dataset containing 180,000 rows. There are 7 computed columns. I'm programmatically adding about 160 new columns which are not computed. I notice that as I'm doing that I get messages in the lower left corner like "evaluating V0 Quarter", "evaluating Year-Week", ... "evaluations done". These are the names of my computed columns. I don't need the computed columns to add the new columns.

Is there a way to temporarily "suspend" formula evaluation? It seems to be adding quite a bit of time to the process.

Thanks,
PeterRe: JSL Performance and Computed ColumnsThat worked great! For a large dataset I got my processing time down from 3 minutes to 41 seconds.

Thanks a lot,
PeterRe: JSL Performance and Computed ColumnsThis example may help ...

dt = current data table();
dt << suppress formula eval(1);

add a bunch of columns;

dt << suppress formula eval(0);