Reddit Sucks

  • 0 Posts
  • 31 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle






  • iZom@feddit.uktoMemes@lemmy.mlMe Trying To Use The Internet
    link
    fedilink
    English
    arrow-up
    25
    ·
    1 year ago

    Early 2000 web was the best web. Our student flat had just moved from dial up to ASDL so download speed felt incredible. I would StumbleUpon new an fantastic websites all night long. Play Flash games for hours. Or with friends, gross ourselves out on rotten dot com. TPB and Limewire to build my music library, but always seeding above 1 of course because sharing is caring. And not forgetting the chatrooms…
    When Jack from Lost said “We have to go back!!”, this is what he was talking about.













  • Glad this is working for you. Using TOP probably was a bad idea and I think the way you used RANK <=1000 is a better approach.

    If there was a way to safely exclude any of the records - like if you knew that when published was older than X days/months/years it would never make it into the final results, you could filter them out before ranking them. That might squeeze a little more performance out of the query, but could be risky if the data isn’t predictable enough.