After moving our Piwik setup to a new server we noticed that some of the archive data wasn’t beeing built correctly by the cronjob for some sites. The monthly and daily views were all showing zero visits, even though they were beeing locked in the live view.
So we removed all archive tables and intented to rebuilt all archives using console:
./console core:archive --force-all-websites --force-all-periods=315576000 --force-date-last-n=1000 --url=http://piwik.mydomain.de -vvv
The database contains about 1.000.000 rows in the log_visits table for about 40 sites. Not much from my point of view.
Yet still the process for the first site (about 120.000 entries) is taking 3 hours already. The period = day routine took 87 minutes (!).
Is this normal? Is it really going to take like a week to rebuilt archive data for all sites? There must be something wrong?