Leaderboard

Thanks, I'm surprised there hasn't been more response to this. It's pretty much the most powerful tool I've ever built... statistically speaking. Personally, I love it. My Average also works with all of the ISPs, cities and countries in the database. Those areas are in development but will be released in iterations soon. I'm using it right now and... to me, it's crazy to see years of data plotted out in front of me, so quickly. Many of the queries aren't even close to optimized or indexed but it can still make it happen like lightning. Around 2011/2012 I changed the way providers were being logged to the database, this tool combines the old data with the new data for its calculations so I'm able to get full records going back to 2005. All in milliseconds. (actually the database predates that but an early error reset all of the dates to 2005... whoops! Too late by the time I noticed. Live, learn, be happy.) These are extremely heavy queries to the database but using some of the same strategies that I use for hoststats I'm able to make these pages render for you in under 0.05 seconds. Behind the scenes these queries take minutes but TMN is in the background pre-fetching and caching calculations. Check out how much Hughes Net has improved over the years. LOL, that 2nd video was copyright claimed for the audio before I could even post this. (I mean right as I pasted the link) Youtube is on it! That's good, that dude deserves credit. So you might see ads just on that 2nd video... just wanted to share what I was really listening to right now.