Reddit’s database was pretty poorly designed. They designed it to be really flexible so they could make changes easily early on, but it was highly inefficient. I don’t know if it’s still like that, but the old website’s source code is public and it is very inefficient.
c/Xporn when X is not sexual. Like r/foodporn, r/earthporn, or r/animalporn.