If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Teamname is not supposed to be part of the username here. Way back when it was agreed with DPAD (I think) that the teamname would be enclosed with [] and I would then safely strip those out which I do.. Yours and a few others seem to be enclosed with () which I've never stripped out. The teamname does get pulled out as it matches with one in the teamdata.

I think I'll just add a piece of code to regex out any /()/ that remain after the team is stripped..

They are still running, but I chose to do some maintenance today on the gargantuan host weekly table to split it into years and it's taking a VERY long time to delete out the older years. In fact the query has been running for 12 hours now This is causing major slowdowns on the rest of the updates.

In hindsight I should have just copied the table over to another machine and done it like that.

It had 750million rows in it and this one is the main cause of the 'sunday' slowdown so that will hopefully be a bit better tomorrow and LOT better next week once I finish.

So let's just hang on and hopefully it'll complete soon. If it's not finished in the next couple of hours though I'm going to kill it..

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

ah, I see the problem. Should be fixed. Looks like only for this particular page. It shouldn't happen I don't think, but in this case I'd left the code in that script to write the cached page AND done an include which means the it's duplicated. It wrote it out correctly, then overwrote it with a blank file..

*EDIT* actually looking at the logs, it was the weekly rollover that took 2 1/2 hours. Mostly inserting the weekly user data as I stopped the weekly host data altogether. I'll optimize those tables this week.