I guess now I know why reddit is so slow.
Among other problems, with a table structure like this it's hard to make good indexes.
Among other problems, with a table structure like this it's hard to make good indexes.
Everything (everything) is cached in memcachdb, which is also where they store their global variables.
It's a terrible design, but it's a web forum. All they need is good horizontal scaling.
And this table structure has nothing to do with Reddit speed. The pages you get, 99.999% of them come from Cassandra and caches, pre-rendered.
So no, reddit is not slow, even less "so slow", and no, the table structure has nothing to do with it's speed.