[Piwik-hackers] Real time stat and archive

[Soren Pedersen]

Hi

I have Piwik running with about 400 sites and approximately 40.000 pageview
/ day. It running great but I'm starting to see what could be potential
performance problems.

The first question is about the cron jobs. They are taking longer and longer
to run (about 5-8 minutes):

?module=API&method=VisitsSummary.getVisits&idSite=all&period=day/week/year

Question: Is there a better way to run these jobs, perhaps iterating through
al sites instead?


My second question is about:

enable_browser_archiving_triggering = true

I need to set this to true in order to give the users realtime statistics
(time_before_archive_considered_outdated = 300). If I don't enable it, the
widgets will be empty for todays stats. I'm worried that this will trigger a
lot of slow queries. It seems to me that the archive process is not started
even though archive hasn't been archived in more than 300 seconds.

Regards,

Soeren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.piwik.org/pipermail/piwik-hackers/attachments/20080727/b5860d9a/attachment.htm