Reddit Sucks

  • 1 Post
  • 30 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle



















  • 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.