How often should the database be reorganized?

How often should the database be reorganized?

This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com.

Reorganising (compressing) the database can help speed up queries and should therefore be done regularly, depending on the type of database. If the ratio of the number of deleted records to the number of existing records is high, queries become slower. 

To avoid this effect with databases, it is best to perform compression regularly with the option "Rebuild address table". This is recommended when about 70% of the data has been deleted, or at least once a year.

Contact the timeSensor LEGAL Support Hotline to request this service.