JSL Performance and Computed Columns

Question

Hello 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,
Peter

pmroz · Answer

That worked great!  For a large dataset I got my processing time down from 3 minutes to 41 seconds.

Thanks a lot,
Peter

mpb · Answer

This example may help ...

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

add a bunch of columns;

dt << suppress formula eval(0);