We are looking to optimise our fox formulas to improve performance and maintenance. Many of them loop over multiple records & reference data within the planning block (e.g. over periods to calculate year totals).
We have been looking at the available documentation and wondered if anyone had some input as to how we could improve performance:
1. In the 'Tips and Tricks' documentation by Marc Bernard it recommends building reference data subsets in Phase 1 prior to executing the main body of the function so the reference data is read only one. However I can't see any way of doing that efficiently without creating some kind of array to store the results. Is this possible?
2. Will the decision to use FOREACH or FOREACH <> IN SELECTION make a difference to performance?
Any ideas or comments on this or any other way of optimising FOX would be most appreciated.