Optimize the structure of your database and increase its performance
If you heavily work with your database, i.e., add but also delete data, it can be helpful to defragment your database from time to time due to the way data is stored in Ninox.
By manually "nudging" defragmentation, Ninox cleans up and rearranges stored data. This optimizes the storage space, which in turn can lead to better performance (access times).
- 1.Open the database you want to defragment.
- 2.Enable edit mode.
- 3.In the database settings, click Options.
- 4.At the very bottom of the page, click the Defragment database button.
When you defragment a database, Ninox reorders data in the background. This can reduce the amount of storage needed and increase performance.
In any case, we recommend defragmenting a database if you have deleted large amounts of data.