Using Calculate for basic mathematical functions is like taking a sledgehammer to crack a nut. Cause Calculate takes ages compared to e.g. ChnAdd, ChnMul, ChnDiv etc. But on the other hand it lets you script formulas in an easy-to-read format.
The idea is to have a pre-processor analyzer for scripts that identifies Calculate commands and checks if these commands could be translated into a series of these basic mathematical functions. If yes, then the script engine should be able to do so in the background in order to speed up the calculation.
Hello Phex,
Thank you for your suggestion. In general, is this an interesting idea, but after discussing it we decided not to take the request in consideration for the following reasons:
In SCRIPT we implemented a profiler to analyze which part of a script takes which time. Our experience is that most of the time it is not the Calculate command, so that we already implemented a tool which helps to speed-up a script.
If the syntax for the calculate command is more or les easy the effort to develop such a pre-processor is also acceptable. But then it is also easy for customers to split the calculator formula by their own.
If the syntax for the calculate command is complex it is much more complex to develop a good pre-processor. As we know are such complex calculator formulas are used not very often in a script and we would prefer to invest in more common functionality. We hope for your understanding.
Again, thank you for your suggestion and greetings
Walter