How to speed up force calculate step?
Hi all,
We are running "force calculate" step to perform force calculation of 80% base entities . It runs for 4-6 hours. How to improve performance , any way run this in multi thread/parallel by e...
Forum Discussion
You can run calculations on different servers using data management jobs. There is a selection box for server in data management jobs.
Other tips:
- Member formulas run in parallel.
- You can aggregate instead of consolidate.
- You can run custom calcs in a parallel.ForEach loop from a extender business rule.
- You can avoid aggregating/consolidating multiple periods. Set the base entities (or a subset of it) to dirty with a business rule and then run a standard aggregate/consolidate instead of force. This can be done with a business rule and a data management job.
And of cause you can combine some of these ideas.
Christian, out of curiosity, would triggering custom calculate using a parallel.ForEach run faster compared to triggering a DM Step for 100 entities? I thought the DM Step would also include some sort of parallelization