[stats-dev] RAW Daily Totals

[Jim C. Nasby]

BTW, this info should be encoded in the XML output somehow, IMHO.

On Tue, Apr 26, 2005 at 06:41:08PM -0500, Jim C. Nasby wrote:
> If you're getting fractional values, you've done something wrong.
> 
> stats=# select sum(work_units*work_unit_disp_multiplier/work_unit_disp_divisor)
> from daily_summary natural join projects where project_id=8;
>            sum           
> -------------------------
>  2394412203.000000000000
> 
> stats=# \x
> Expanded display is on.
> stats=# select project_id, work_unit_import_multiplier,
> work_unit_disp_multiplier, work_unit_disp_divisor, unscaled_work_unit_name,
> scaled_work_unit_name from projects where project_id=8;
> -[ RECORD 1 ]---------------+-----------
> project_id                  | 8
> work_unit_import_multiplier | 4294967296
> work_unit_disp_multiplier   | 1
> work_unit_disp_divisor      | 4294967296
> unscaled_work_unit_name     | Keys
> scaled_work_unit_name       | Blocks
> 
> On Tue, Apr 26, 2005 at 10:19:39PM +0100, Paul wrote:
> > I added a : $par->work_units * $gproj->get_scale(), which I believe should
> > give the scaled value i.e. blocks
> > 
> >   <stats date="2005-04-24" work_units="7133289.41744" participants="2140"
> > teams="471" /> 
> >   <stats date="2005-04-25" work_units="7805333.68763" participants="2348"
> > teams="519" />
> > 
> > Does 7,805,333 look about right for a day's blocks? That looks a bit high to
> > me - decibel? :)
> > 
> > With regards to your php code, I didn't actually look at it that much as I
> > saw it after I'd looked myself, but looking now..
> > Other than the fact I think in one of the includes, we define $gdb, I'd say
> > it looks fairly spot on.
> > 
> > Paul
> > 
> > -----Original Message-----
> > From: stats-dev-bounces at lists.distributed.net
> > [mailto:stats-dev-bounces at lists.distributed.net] On Behalf Of Travis
> > Sent: 26 April 2005 20:10
> > To: stats.distributed.net Development
> > Subject: Re: [stats-dev] RAW Daily Totals
> > 
> > I have already worked out the parsing of the XML for the daily stats, as far
> > as the team stats go, I think someone else's input would be more valuable as
> > I will probably not be using the team statistics, just the totals.
> > 
> > But, I really do appreciate the daily totals.  The only problem I have is
> > that they are key and not blocks.  My statistics are all done in blocks, as
> > with most of the statistics on dnet.  Is there a way to convert the keys to
> > blocks correctly and quickly?  Thanks.
> > 
> > Also, I was just curious...  Did my code work?  It was my first attempt at
> > PHP, so I am wondering if I did even somewhat close to what I was going for.
> > Thanks again!
> > 
> > -Travis
> > 
> > >
> > > Travis: Depending on your knowledge/use of xml in things, feel free to
> > take
> > > a look at the team ones, and suggest the best format for the xml file I
> > > knocked up.
> > >
> > > Paul
> > >
> > 
> > _______________________________________________
> > stats-dev mailing list
> > stats-dev at lists.distributed.net
> > http://lists.distributed.net/mailman/listinfo/stats-dev
> > 
> > _______________________________________________
> > stats-dev mailing list
> > stats-dev at lists.distributed.net
> > http://lists.distributed.net/mailman/listinfo/stats-dev
> > 
> 
> -- 
> Jim C. Nasby, Database Consultant           decibel at distributed.net
> Give your computer some brain candy! www.distributed.net Team #1828
> 
> Windows: "Where do you want to go today?"
> Linux: "Where do you want to go tomorrow?"
> FreeBSD: "Are you guys coming, or what?"
> _______________________________________________
> stats-dev mailing list
> stats-dev at lists.distributed.net
> http://lists.distributed.net/mailman/listinfo/stats-dev
> 

-- 
Jim C. Nasby, Database Consultant           decibel at distributed.net
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"