[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