DB maintenance
The Apache Derby database provides a set of maintenance functions which lead to a significant performance improvement.
OmniPOS provides a DB maintenance component (GK_STATS) which provides access to these functions.
Note:
We strongly recommend enabling and configuring these maintenance functions according to your needs.
These functions can be triggered separately via a scheduler for the master data database and transaction database.
The general DB stats configuration can be found in:
- config/standard/parameter/server/db-stats-service.properties
The scheduler configuration can be found in:
- Full POS/Flow Service
- Master data database: config/standard/parameter/client/scheduler_client/scheduler-md-db-stats-recalculation.properties
- Transaction database: config/standard/parameter/client/scheduler_client/scheduler-tx-db-stats-recalculation.properties
- Smart POS Service
- Master data database: config/standard/parameter/server/scheduler_smartpos/smartpos_scheduler-md-db-stats-recalculation.properties
- Transaction database: config/standard/parameter/server/scheduler_smartpos/smartpos_scheduler-tx-db-stats-recalculation.properties
Internally, the functions perform specified operations for all tables which are available in the schema.