Hi Support Team,
I posted a question of the Grid formula performance issue a few days ago and with the kind help of Mike, I found the FormulaManager.CalcFrequency was set to Synchronous. After I set it back to Asynchronous, the performance issue was resolved. But I found my CPU was always around 27% used long time after data populated (it seemed never stop), if I set FormulaManager.CalcFrequency to Synchronous, CPU was not used after data was populated.
Is there anything I can do to stop Formula Asynchronous from using CPU resource? thank you.
for your information, I am using version 2011.2.
Kind Regards,
Russell
Hi Russell,
Hm, that's odd. Are you sure that all calculations are complete? The CalcManager will calculate the visible cells in the grid first, whenever possible, but then it will work on cells that are scrolled out of view in the background. So if you have a lot of data in your grid, it could be the out-of-view cells being calculated.
It's also possible that some of your formulas are using functions that are always considered dirty and are therefore recalculated constantly. The Date function is in example of this type of always-dirty function. Perhaps that's why your application was using Synchronous in the first place?