quite a vague task but I'm sure there's some low-hanging fruit
obviously the current hot_rank sort is not scalable but I don't know where to start with taming it
I've now added a cache column for likes, which seems to speed up hot ranking a fair bit