At 3/10/09 08:54 AM, Slightly-Crazy-Dude wrote:
So, how does this site track the 500 accounts that are at the top?
If I remember correctly a guy called ShittyKitty made something similar back in 03/04 that would track all the users posting regularly, and set them up in a format similar to yours. However Wade went apeshit saying it was a severe strain on the NG servers and was similar to a DDoS attack and implored him to stop it along with an attached threat of deletion and a call to the FBI. I have no idea if this is the same as what this site is doing but I thought I'd throw it out there for your consideration.
every 1 hour it queries the userpage and takes the postcount. It's the same as me loading the page in my browser, 700 times. It'll affect the servers ever so slightly, but they're capable of handling massive amounts of users, so an extra 700 page loads won't affect them too much, however if Wade wants to go apeshit, he can and I'll remove it.
Every 1 hour it takes every username from the database, loads up <user>.newgrounds.com, fetches their postcount then adds it to the DB then it displays the top 500.