How many work are done by LINUX, Mac and M$ ?
Is it possible to create a statistic ?

mfg
falk

This info can be found in the project stats (not in the combined stats!)

BOINC combined stats have no " Hosts by Operating System "

Why not ? It would be helpful !

mfg
falk

[url=http://www.boincstats.com/forum/viewtopic.php?p=739' target='_blank]http://www.boincstats.com/forum/viewtopic.php?p=739[/url]

5.60 is testing a new Cross Project Host ID in S@H and Alpha only so far. Look for host_c pid. Other projects will get this as the server code is upgraded.

I saw the <host_cpid> exported in the SETI XML file, but it had no value.

1 thing is certain: combined host stats will cost me an awfull lot of space in the database

Why not calculate it on the fly in the query for display.

John,

I know a little about relational databases, even though under ASP in stead of PHP.

As programmer you want your site to display the data as soon as possible. This means trying to have as much data readily available in the database as possible.

Advantages :
1. Visitor more satisfied as he/she doesn't have to wait long.
2. Serve more people in less time so MORE satisfied people.

DISadvantages:
1. Hell of a lot of EXTRA database room needed. Administrator needs to evaluate if that room is available.
2. Heavier serverload/longer processing time during update. The administrator needs to evaluate how long and by how much the performance decreases during the update.

Disadvantage 2 needs to be carefully set of against the advantages as during the update the database and thus the site will be more and/or longer sluggish in response.

Seeing Willy's response my guess would be that he thinks that the "on the fly"calculation will slow the site (meaning being able to serve less people at the same time) and thus hinder the visitors more than when the site does the calculation during the general update.

Of course this effect will only increase with a growing database.

Hope this clarifies things a bit.

Garindan has a good point here.

I included the hosts CPU brand/OS in the combined project stats, but as you may notice, it takes a while to load. This is all database related, the script has to 'walk' through all the projects and check a total of 245,000 hosts twice.

I need to look into this and make some changes, I don't like the load (time) at the moment.

Thanks for the compliment Willy.

I tought myself all I know about programming database scripts under ASP and even though I don't know anything about PHP I imagine things are roughly the same under PHP.

My understanding is that the things I said above are important for any "active server" programmer. It even needs to be re-evaluated regularly as the database / usage of the site increases.

Bas

thx it is verx interesting the statistic about the OS ! I belive in linux and hope the world see the OS of the future !!

Thanks again for the new statistic !

P.S. I have donate some money for the website !

one member of the
The Linux Community