How long do I need to keep my log_visit if


#1

Hi,

remember I disabled the lines that use log_visit to count uniq VISITORS ?
http://forum.piwik.org/read.php?2,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 ?

cheers,
-lorieri


#2

Sorry, I meant, piwik_log_link_visit_action

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

tnx


(Matthieu Aubry) #3

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


#4

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: