Subscribe Bookmark RSS Feed

JSL Performance and Computed Columns

pmroz

Super User

Joined:

Jun 23, 2011

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
2 REPLIES
mpb

Super User

Joined:

Jun 23, 2011

This example may help ...

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

add a bunch of columns;

dt << suppress formula eval(0);
pmroz

Super User

Joined:

Jun 23, 2011

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

Thanks a lot,
Peter