Originally Posted by Gopher_FreeDC
Guys, I'll say this so Bok don't have too. Thanks..
I guess that means I'm going to have to do something special for you... hmm I'm toying with ideas and a new layout engine....
Rated IE 7+ , FF 3+ , Safari, Chrome, I'm working the kinks out.....Totally AWESOME!!!!Yes, Gopher is making some real nice changes to the frontend! Moving all our ajax features over to jquery and utilizing some of it's strengths (as well as some nice new HTML5/CSS3 stuff too )
Let me say a huge thanks to everyone who donated! I ended up ordering 2xIntel 510 SATAIII 120Gb drives on tuesday and they should arrive today!
It'll be a 'triple whammy'.
1. CPU is faster
2. new SSD's will move data faster
3. I'm going to use the opportunity t make some architectural changes to the database tables and the perl scripts which parse and insert the data, on a basic level I'm going to split each of the main (team/user/host) tables into two. First one will contain the main data which changes with every update, the second one will contain the rest of the data. This way I can reduce the amount of data being replicated from the calculation database to the web facing one on a regular basis.. For instance the host table with it's indexes is 11Gb right now and that gets replicated across roughly 20 times a day. It takes a few mins. I can probably cut that down to <2Gb for the main data.
I think it's going to be *good*, quite a bit of work to do..
Reply With Quote
. That is just mind numbingly fast! So glad this all came together. Thank you to all the helpers, there are several on this project who wished to remain anonymous, and this is a public thank you to y'all.And to BOK- the least we could do for such a generous benefactor- not just to our team but to the entire BOINC community. My hat is off to you, Sir! Enjoy your new database monster rig. 
