iZom

u/IntergalacticZombie@feddit.uk
0 posts · 30 comments

Recent posts

No posts.

Recent comments

on (Re)bracketing · c/microblogmemes · 10 pts · 2y

Does that mean the 'P' was supposed to be silent? You don't say puh-terodactyl without getting laughed at in school... Um, probably!! So, is it a actually called a helicoter?

on *Permanently Deleted* · c/videos · 13 pts · 2y

It takes a lot of money to bribe um... I mean lobby for change. By being disruptive you raise awareness and get media attention that makes the situation harder to ignore.

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.