[Piwik-trac] [Piwik] #85: Temporary archives should be deleted
Piwik
trac at piwik.org
Thu Jan 24 03:29:31 CET 2008
#85: Temporary archives should be deleted
----------------------+-----------------------------------------------------
Reporter: matt | Owner:
Type: Bug | Status: new
Priority: critical | Milestone: RobotRock
Component: Core | Version:
Keywords: |
----------------------+-----------------------------------------------------
When archiving data for a period that is not finished (today, this week,
this month, etc.) the archive is not definitive and one day piwik will
compute the data of this period. At this point we will still have the
temporary archive in the DB ; it should be deleted.
* day: delete where period = day and date1 = DATE(ts_archived)
delete archives for a given date that were archived this same day
* week: delete where period = week and date1 = startWeek and date2=
endWeek and DATE(ts_archived) <= date2
etc.
--
Ticket URL: <http://dev.piwik.org/trac/ticket/85>
Piwik <http://piwik.org>
Piwik, open source web analytics software
More information about the Piwik-trac
mailing list