Recent Milestones across BOINC projects Not Updating Properly

[bikerbrent]

I have two entries in this area for Einstein@Home. The first for Tuesday, 3 August 2010 which shows 100,000 units and a second for Einstein@Home for Tuesday, 31 March 2009 which shows 1,000 units which is hung in the display despite the fact I currently have completed 126,023 units. How can I fix the 31 March 2009 so it updates correctly.

[Bok]

Took me a while to find you in the stats based only on the information you have provided. I'm guessing that this (http://stats.free-dc.org/stats.php?page=userbycpid&cpid=f2755ef54743ebf022adf384be065f88) is you ?

Is the issue due to not having all of the other milestones inbetween?

The reason for this 'odd' behaviour is actually a little complex. There are two tables for the milestones, one is current and one is 'archived'. The archiving is not automatic at all so right now contains all milestones older than March 1st 2010.
On that paqe I retrieve the latest milestone from each project from the current milestones and seperately do the same with the archive ones. This is a little clumsy though. In fact the sql I use to get these is the worst performing sql in the whole stats system!

It's an area I need to look into so it's high on my radar right now. The 1000 milestone is certainly correct though. As an FYI full milestone list below for you in EAH (I also need to provide a means to display these somewhere...)


mysql> select stat_date,milestone from boinc_milestone_archive where cpid = 'f2755ef54743ebf022adf384be065f88' and proj = 'eah';
+------------+-----------+
| stat_date | milestone |
+------------+-----------+
| 2008-08-12 | 100 |
| 2008-08-12 | 200 |
| 2009-02-05 | 500 |
| 2009-03-31 | 1000 |
+------------+-----------+
4 rows in set (0.00 sec)

mysql> select stat_date,milestone from boinc_milestone where cpid = 'f2755ef54743ebf022adf384be065f88' and proj = 'eah';
+------------+-----------+
| stat_date | milestone |
+------------+-----------+
| 2010-03-17 | 2000 |
| 2010-03-19 | 3000 |
| 2010-03-22 | 5000 |
| 2010-03-24 | 6000 |
| 2010-03-26 | 7000 |
| 2010-03-28 | 8000 |
| 2010-03-30 | 9000 |
| 2010-04-01 | 10000 |
| 2010-04-20 | 20000 |
| 2010-04-27 | 25000 |
| 2010-05-05 | 30000 |
| 2010-05-20 | 40000 |
| 2010-06-08 | 50000 |
| 2010-06-19 | 60000 |
| 2010-06-30 | 70000 |
| 2010-07-13 | 80000 |
| 2010-07-25 | 90000 |
| 2010-08-03 | 100000 |
+------------+-----------+
18 rows in set (0.00 sec)



Hope that helps. I'm going to try and do some updates to this area tomorrow...

Bok :)