Improve performance: Save Calculated values in Static fields
Views of the tables can sometimes take longer to be displayed due to the functions which are calculating the values. Formula fields have to be calculated every time the view is opened. It is especially important not to have many formula fields with select statements in them.
Instead of using formulas you could switch to a static number field and use it in combination with "trigger on update" to calculate the values. Then you have the advantage that the calculations will not have to run every time you just open the table but only when you modify or create new data.
Static (or 'Local fields') are faster, because they don't require additional data to be loaded.
Work faster and have fun with Ninox!
- 1 yr agoLast active