Jump to content
CA3LE

My Average Tool

Recommended Posts

The Hourly Average tool has been converted to also average Date/Day, Day of Week, Month and Year and has been renamed My Average.

 

 

Averaging speed test results by hour, day, day of week, month and year can help you pinpoint slow times.  Members with long TestMy.net history can aggregate all the way back to their original results.  So you can see how your speed has improved (or not) over the years.

 

myaverage?hostQ=&dateFull=&q=CA3LE&var=Year

 

Hope you like it.

Share this post


Link to post
Share on other sites
On 5/24/2019 at 9:32 AM, ShakTib said:

Oh this is nice. ^_^

 

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.  ;) 

Share this post


Link to post
Share on other sites
On 5/21/2019 at 5:33 PM, CA3LE said:

 

You're welcome!  I'll start explaining with videos like that more often.

 

 

Cool, I'll look you up.

            Thanks but I haven’t uploaded anything yet, although I do have a wide variety of playlist content for both the discerning and the  non-discerning viewers 🤯

Share this post


Link to post
Share on other sites

I agree this is really cool.  Interesting to see my speeds outperforming the Dow Jones over the years.  :)   Right now my pet project is figuring out what router to get when my Apple Airport Extreme starts approaching obsolescence, since Apple has exited the wireless market.  I understand there are some really exotic new products from mainstream manufacturers but am overwhelmed with reviews and data at the moment, and hope the classic Apple simplicity and reliability is part of other router manufacturers' culture and tech.

 

Best regards, CA3LE.  We haven't conversed in a while but I'm so grateful you have stayed at this.  

Share this post


Link to post
Share on other sites
3 hours ago, mvbmac said:

Interesting to see my speeds outperforming the Dow Jones over the years.

 

Big time. :-P --- although your upload has been leveled out for a while... it's still a great upload speed.

 

myaverage?q=mvbmac&var=Year

3 hours ago, mvbmac said:

Right now my pet project is figuring out what router to get when my Apple Airport Extreme starts approaching obsolescence, since Apple has exited the wireless market.  I understand there are some really exotic new products from mainstream manufacturers but am overwhelmed with reviews and data at the moment, and hope the classic Apple simplicity and reliability is part of other router manufacturers' culture and tech.

 

Yeah, it is too bad.  You know they could make some amazing new Wireless 6 Airport router... where you could add on your own number of satellite units, with ethernet backhaul capability.  Apple would do it right and make bank.  But if they go at that market again I think they need a faster refresh cycle.  I don't see Apple putting resources into that right now.

 

I was hoping that my Netgear Orbi (AC3000) was going to be better.  I'll be ordering a couple different routers soon for a shootout.  

 

One that's high on my interest list is the Netgear XR500 running Duma OS -- which is supposed to be easy (intuitive) and powerful at the same time.

 

This is one time I've strayed away from gaming routers (because I wanted a mesh system), I wish I had just waited.  Because now, Netgear's gaming routers can create mesh networks with the NIGHTHAWK X6S (EX8000).  Not saying the Orbi is terrible but I'm positive the XR500 and X6S will out perform it.  Still creating a single seamless network like the Orbi, not an extended network.

 

Linus Tech Tips (that links to his forum) just did a review on the XR500 -- guess I'll link to him even though he seems to have a hard on for speedtest.net.  Maybe he just doesn't know any better yet. :evil6:

 

 

3 hours ago, mvbmac said:

Best regards, CA3LE.  We haven't conversed in a while but I'm so grateful you have stayed at this.  

 

...me too brother.  I'm still nowhere near complete.  And thank you!  Glad to see you're still around.  :-D   Always love to see TMN veterans!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...