Storage affects of auto-create

Each Top Mover calculation generates another row in the database.

  • For the above data set, the number of rows that are generated per run is 500,000 new rows.

Data retention

Top Mover data is retained based on the configured setting for data retention.

  • Top Mover (daily)-Days Retain - Number of days to retain daily Top Mover data
    • (365 is the default setting)
  • Top Mover (hourly)-Days Retain - Number of days to retain hourly Top Mover data
    • (120 is the default setting)
    • See "Settings" in the Unica Discover Administration Manual.

Top Mover data trimming must be enabled, or data is never trimmed.

  • For more information, see Data Trimming - Top Movers in "Settings" in the Unica Discover Administration Manual settings.

Maximum storage

For our example data set:

Table 1. Storage Impacts of Auto-Create

REQTEXT
Type Rows per Data Collector run Number of runs per day Number of days Total rows
daily 500,000 1 365 18,250,000 rows
hourly 500,000 24 120 1,440,000,000 rows