How long do I need to keep my log_visit if


remember I disabled the lines that use log_visit to count uniq VISITORS ?,88411

since I disabled it and I run archive every 3 hours, does it mean I can keep only 2 or 3 days of logs in log_visit table ?

and maybe move it to a backup somewhere else ?


Sorry, I meant, piwik_log_link_visit_action

but, what happens if I keep only few days for log_visit ?


Yes should be OK ! if you run archive.php and archive every day you only to keep 1 day :slight_smile:

at core/ArchiveProcessing/Period.php line 82, I’ve changed this:

if($name == 'nb_uniq_visitors') continue;

to this:

if($this->period->getLabel() == 'week' and  $name == 'nb_uniq_visitors' ) continue;

it will mess with user reports for a while, but it is the best I can do for now.
the future plan is to create a user table by month, that looks like will be far smaller than log_visit

thanks :slight_smile: