About the use log tables

The users' view and update activities in the WorkZone clients are saved into one or more current use log tables named current_use_log_<0..n>. These tables have no indexes. You can set up the number of tables to use for logging when users view or update data, and in this way avoid heavy load on the use log. See Set up the use log.

Every night, the current use log tables are transferred to monthly use log tables named use_log_<yyymm>. The monthly tables are indexed. WorkZone Configurator uses these tables to display data from the use log. This means that you can only see the log entries that have already been consolidated with the monthly log in WorkZone Configurator. It is possible to force the use logs consolidation manually. See Use logs.

Maintenance of the use log

Every month you need to drop the monthly log tables that you do not want to keep.