Defragment database

Optimize the structure of your database and increase its performance

If you heavily work with your database, not only add but also repeatedly 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 "triggering" defragmentation, Ninox cleans up and rearranges stored data. This optimizes the storage space, which in turn can lead to better performance (access times).

More on fragmentation (external link)

How it works

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.