Hey Everyone,
As if you haven't noticed our site has been dropping almost daily. This is mostly cause the way I built it didn't quite take into account the shear volume of people that will be using it. My Server Guy/Advisor and I are building out some new optimization tools that should help speed things up and stop the bottleneck that has been happening. It's going to take a bit to fix but I hope to have these issues and trouble spots fixed soon. I'll keep you all posted. I've disabled player profiles for now as thats one of the areas causing issues. Once I have the new tools in place i'll relaunch it. Thanks for understanding and please continue to be patient.
Foghladha
P.S. Go figure quering 75,000+ records to find a persons ID in a long string of id's several times on the same page doesn't work so well. Building new indexes to help speed the process up. But I also have to rewrite about 65 places that query those results. Time to play with some inner joins :D.
» Edited on: 2012-06-07 11:54:36