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 Engine
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).