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.

    • Related Articles

    • How do I optimise the security of my database?

      This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. Since lawyers handle particularly sensitive data, the security of the timeSensor LEGAL database is an issue ...

    • How can I optimise the security of my database?

      Since lawyers deal with particularly sensitive data, the security of the timeSensor LEGAL database is an especially serious matter. The article below provides information on how to ensure the safe operation of the database. General information This ...

    • Logging the timeSensor client app onto the database server

      This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. General The timeSensor client app is a rich client, i.e. a generic client with which you can log on to a 4D ...

    • How Can I Create a Shortcut to the timeSensor® LEGAL Database?

      When you start the timeSensor LEGAL client app, you will be asked which server you want to connect to (see C1. How do I connect with the timeSensor LEGAL Server?) If you want to avoid this step, create a *.4dlink file shortcut directly to your 4D ...

    • My client keeps losing connection to the server. How can I find the error?

      In order to be able to work with the database without any problems, you need a perfect network connection to your server. Various sources of error can affect the connection between 4D Client and 4D Server: Sudden workstation sleep Unreliable network ...