Database Optimization

In order to maintain database performance levels, tables in which rows are frequently inserted and deleted need to be optimized at regular intervals. The Content Store incorporates a service for this purpose, called OptimizeTables. The service is disabled by default. To enable it, add a file called configuration-root/com/escenic/service/database/OptimizeTables.properties to your common configuration layer, and set the following property in it:

serviceEnabled=true

By default, the service will then run at 05:05 each morning, and optimize the following tables:

ECELocks
ResourceLock
RemoteNotification

You can modify these (and other) defaults by adding further properties to the file. To see all available properties, examine the OptimizeTables service settings in the escenic-admin Component Browser (see Component Browser).