The formula parsing uses the principle of descending recursion. However, some expressions are evaluated several times because it works by trial and fail.
It could be a nice addition, and overall optimisation to add a caching system to store some evaluations in a smart way, to remember it worked, or caused an error and drastically reduce the evaluation time in very deep formulas.
The formula parsing uses the principle of descending recursion. However, some expressions are evaluated several times because it works by trial and fail.
It could be a nice addition, and overall optimisation to add a caching system to store some evaluations in a smart way, to remember it worked, or caused an error and drastically reduce the evaluation time in very deep formulas.