Automatic Statistics Recalculation

We recommend enabling the automatic statistics recalculation (built in) feature of Derby.

This feature was disabled in the past for two reasons:

• Statistics recalculation consumes lots of resources (CPU+RAM+IO). If it takes place during business hours, it is likely to affect the POS performance.
• As we take care of statistics ourselves, there is no need for Derby to recalculate statistics on its own.

With disabled statistics recalculation, however, the Import Data Pump takes much longer and statistics are only recalculated if outdated.

This feature is enabled by default within config/standard/parameter/client/clientSystem.properties:

 SystemConfig.systemProperties.9.propertyKey=derby.storage.indexStats.auto
SystemConfig.systemProperties.9.propertyValue=true