Hello Mauro.

Performance slowdowns in Ninox can be caused by various factors, but there are some optimizations you can try to improve efficiency:

- Optimize queries and formulas:

• avoid using complex formulas directly in fields, especially if they involve multiple searches in large tables;
• if possible, store calculated values in dedicated fields instead of recalculating them each time

- Limit the number of displayed records:

• if your "Attività" table is large, try filtering the displayed data in views to load only the necessary records.

- Minimize the use of complex relationships:

• too many relationships between tables or recursive links can slow down loading times. Ensure that each relationship is truly essential;

- Optimize triggers and scripts:

• if you have "On Modify," "On Create," or "On Delete" triggers, check that they do not perform heavy operations unnecessarily;
• avoid using nested loops or operations that iterate over too many records.

By applying these optimizations, you can significantly improve the responsiveness of your Ninox database. If the issues persist, consider reaching out to Ninox support to check for possible server-side slowdowns.

Hope this helps!

   Fabio

One thing that caught me out in the beginning is creating formulas and displaying them in the table view. If you can imagine doing that with your Financial table, that forces Ninox to run the code for each record.

Using dashboards and creating summary tables helps to take the load off Ninox when you are doing charts.

I am having problems, when I modify a field and save it takes too long, however other times it is not is random.

Take a look at this post. I make a reference at the beginning to how I first tried to do stats and how it ruined my DB.

Let us know if you are trying to do something similar and maybe we can help redesign things so it runs faster.