18 ms·
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.
by ars 14y ago
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.
- batista 14y agoCompared to what? Reddit is damn fast. 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.
- eco 14y agoSigned-in reddit is one of the slowest sites I use. It is, however, very fast for what it is doing. I have no complaints about the speed, only wishful thinking.
- Acne_Researcher 14y agoI concur. Signed-in reddit is very slow. Signed-out reddit is better but still feels slow. Perhaps I am spoiled by Facebook, Google & co.
- wisty 14y agoNo, it's not. 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.