“Top Posts” format has been updated, upgrades, and given a new paint of coat

I’m happy to mention that the “Top Posts” section of the site is officially back in action, for the longest time it was down and showing a broken page, if only because I had every intent of fixing it. You see, the way I originally wrote that page made it do about 30 different heavy queries on the site’s database nearly every time anyone loaded it. 10 people hit it? 400 queries! Some of those queries would take minutes to complete and would slog down the rest of the server whilst doing so.

That is no more!  Now I have tikibot doing the queries twice a day, saving the values to a stored value, then that value is cached along side the page and if you or 200 other people hit it all at the same time, the impact on the rest of the site is minimal at worst.

As is the usually though, while working on this I found like 5 other things that I want to fix, but this was a big one and I wanted to celebrate the win!



  • Leave A Comment

    Subscribe
    Notify of
    3 Comments
    Inline Feedbacks
    View all comments
    Advertisements Alcohol Animated Images Architecture Art Awesome Things Batman Bikinis Black and White Cars Comic Books Computers Cosplay Cute As Hell Animals Donald Trump Drugs Fantasy - Science Fiction Fashion Food Forum Fodder Gaming Humor Military Motorcycles Movie Posters Movie Reviews Movies Music Music Videos Nature NeSFW Politics Religion Science! Sexy Sports Star Trek Star Wars Technology Television Vertical Wallpaper Wallpaper Weapons Women WTF

    480 x 360 500 x 281 500 x 375 500 x 500 500 x 750 600 x 450 600 x 600 600 x 750 600 x 800 600 x 900 640 x 480 640 x 640 640 x 800 640 x 853 640 x 960 720 x 720 720 x 960 750 x 600 800 x 600 800 x 800 960 x 720 960 x 960 1024 x 683 1024 x 768 1080 x 1080 1080 x 1350 1200 x 630 1200 x 800 1200 x 900 1280 x 720 1280 x 800 1280 x 960 1280 x 1024 1440 x 900 1600 x 900 1600 x 1200 1680 x 1050 1920 x 1080 1920 x 1200 2048 x 1536 2560 x 1440 2560 x 1600 3024 x 4032 3840 x 2160 x

    ABoringDystopia Amoledbackgrounds AnimalsBeingDerps ATBGE awfuleverything Celebhub Celebs CityPorn comicbookart conceptart cosplaygirls Cyberpunk EarthPorn Eyebleach Faces FreckledGirls funny General Uploads gentlemanboners hmmmm Images Sub Space ImaginaryStarships ImaginaryTechnology InfowarriorRides interestingasfuck MarchAgainstNazis marvelstudios MCS Plus memes MilitaryPorn nocontextpics OldSchoolCool pictures PoliticalHumor PrequelMemes PropagandaPosters RetroFuturism sbubby StarshipPorn startrekmemes Storminator Super News Thanks I Hate It UrbanHell wallpaper

  • here's some related content from the store: