Search results

Why are you updating yesterday's total with today's number?

So you just compare the total credit with previous total credit to get the Delta for this interval?

so the user xml <user> <id>1</id> <name>S C</name> <country>Sweden</country> <create_time>1483633404</create_time> <total_credit>72451572.864025</total_credit> <expavg_credit>0.094425</expavg_credit> <expavg_time>1530457502.188703</expavg_time> <cpid>ebeb727389d386958c5c414f38ca09bd</cpid>...

So you have to follow their update schedule then? Each project has different update frequency?

isn't https://sech.me/boinc/Amicable/stats/ the latest stats from project Amicable? Typically refreshed every 24hrs?

ok so the stats folder represents only new data from the last 24hrs? you add the number there to existing numbers? The Team id is just local to the project? There is no Boinc Team ID? How do you match across different projects? the user has cpid as unique identifier. I need to understand the...

Give me the list of projects you need to process.

There are good points to videos as well, I can play it in the background while I do stuff.

And it's down again :(

oh oh I am getting the server error has occurred issue.

that is a lot of tables. the scripts you generated didn't work as an import in mssql cus the syntax was not correct so I just installed mariadb and looked at some of the tables. In general, text make poor keys, so for project you should have a ProjectID that is integer and is the PK.

drives are so big these days I am not sure a rebuild is worth it. couple it with real chance of second drive failing while rebuilding, Raid 5 is not really viable.

No, just exports the db without the data. I don't know mariadb's particular db design export syntax I'll take a look later when I have some time.

You need a User table that has a say autonumber as the PK (LocalUserID for example), the the Boinc User table, then Project table. Add LocalUserID to the BoincUser table, then you need another table, let's call it LocalUserProject where you list the LocalUserID with the ProjectID. That way your...

Am I understanding this right? Boinc_User table has ProjectID and UserID as PK? Why not just UserID and add index on ProjectID? Typically you try to normalise the data so that you only update what you need to update. so User in one table, Project in another, the daily transactions you download...

there are no indicis on key fields like user id and project id?

good god, this is negating the purpose of rdbms lol. Is there a reason you are downloading every 15 minutes? Can you not just download 1 file at a fix time, call it midnight, and specify the download is for the day and then process it? I am assuming the donwnload includes only whoever is active...

it's not an hardware issue, it's the design of the db/queries/stored procs. You can have a table that stores the data needed to feed the webserver, it's a static table that you update after you compute the results. Are you computing results as a scheduled task? Are you assuming everyone will...

your machine is more suitable since it can handle hundreds of browser tabs.

Never mind.