I just want to mention that Cron archiving really does wonders for performance.

I've got a site that is receiving nearly 10,000 daily uniques since Google's last [panda|penguin|whatever] update in May, and while Piwik's performance was not terrible, setting up the cron a few weeks ago made the whole experience very snappy.

Thank you for your work halfdan!