Been looking at your stats pages.
Was wondering how they're generated? SQL and PHP?
What sort of space do they take up on the server and what load do they use when making them?
And would it be cheeky to have a look over the code?
Senior Member
Been looking at your stats pages.
Was wondering how they're generated? SQL and PHP?
What sort of space do they take up on the server and what load do they use when making them?
And would it be cheeky to have a look over the code?
Seeker of the exit clause
Moderator
Reading Ot's stats code - that's kind of amusing.
I tried that once.
Left me with an enormous headache.
Don't get me wrong.
Possibly the fastest stats engine there is.
It is perfect, just kind of hard to "read"
I'm not going to spoil Ototero's fun.
Grab some throw pillows.
You will need them.
You will fall off your chair if he tells you.
. . . . . ___
. . . . . . .\___/\______
. . . . . . .\__AMD___\
---------------------------------------------
Delusions of Adequacy
Moderator
Ok Drezha, you asked for it.
I use 3 Excel spreadsheets. 1 for the teams positions, 1 for non-boinc teams members and 1 for boinc team members.
Each fetches the data, parses it, homogenises it. The team position sheet also formats the complete html page. I just have to FTP it to our server.
The 2 team member sheets each create a csv file. These 2 are loaded into a program called DataEase (for Dos!!!!!). This does the crunching and complete html page creation (Active people within the last 24 hours and complete member results, both boinc and non boinc) which is 4 pages in total. These 4 pages are FTPed as well.
The DataEase phase takes about 1 minute.
How does that all sound?
Darkness isn't there, but you can't see through it
Moderator
My brain hurts now...Originally Posted by Ototero
Senior Post Whore
Moderator
Its serves as a timely reminder to record here that Ototero's AMD Users stats pages are a fantastic resource. Whilst they are now implemented and running smoothly there was an incredible amount of time, skill, knowledge and effort expended by Ototero in getting the stats to the polished product they are now.
Congratulations. You deserve more money!
Senior Post Whore
Moderator
Yes, it seems difficult to understand but it I understand it is simple for the developer. Keep up the good work Ototero!
Once an AMDuser always an AMD user
Senior Member
Blimey! More person intensive than I expected!
Delusions of Adequacy
Moderator
Nah not really, it only gets tricky when that bloomin' Neogen find another project to add.
Just kiddin' Neo. Keep finding them, especially the non-boink ones
Darkness isn't there, but you can't see through it
Post Whore
Ototero.
Could you talk to Bok and pass along any info that he might need to add Wieferich@Home to his stats?( www.elmath.org )
Me transmitte sursum, caledoni!
I am totally against political jokes....I've seem to many of them elected!!
Delusions of Adequacy
Moderator
We did already.
Darkness isn't there, but you can't see through it
Posting Permissions
Reply With Quote
