TI Process Performance Issue

[dan.kelleher]

A TI Process to load data from an ODBC source is suffering really badly from performance issues.

If the CellPutN() is switched off, the process executes in seconds. The cube that the data is pushed into is quite a large cube with many rules and feeders (both internal and external).

I have loaded data into similar cubes before without performance issues, but this is hanging after the prolog has finished executing and has to be cancelled.

Has anyone else experienced similar issues?

Any ideas would be greatly appreciated.

Thanks,

Dan

[dan.kelleher]

This was down to a SubsetGetSize command residing in the data tab. The subset is dynamic and therefore a CellPutN/ CellGetN causes the subset to be reevaluated each time.

I will switch to a static subset or remove the code from the data tab.

Thanks,

Dan

[ajain86]

Dan,

You are performing conditional checks on the data tab? for which you have a dynamic subset?

What processing are you performing on the data tab that would require the subsetgetsize command?