3 ms·
Actually, I bet you it's a "we hit the database on every pageload" problem.
by joshu 16y ago
Actually, I bet you it's a "we hit the database on every pageload" problem.
- giantfuzzypanda 16y agoYep. That's why you shouldn't have pylons noobs running a site like reddit.
- emmett 16y agoI know the reddit guys, and I can tell you it's definitely not that. Hitting the DB is extremely rare - almost everything comes straight out of cache (either memcache, or memcachedb for caches which are more expensive to rebuild). Execution cost is dominated by the python app servers.
- blhack 16y agoThe overwhelming majority of reddit's pageviews are users that are not logged in, which is very very cacheable.
- emmett 16y agoI am pretty sure this is false. While the overwhelming number of unique visitors to reddit are not logged in, those users are far less engaged than average. Logged in users make up a huge percentage of the pageviews because of their higher engagement level.
- jedberg 16y agoAbout 20% of the users are logged in, and they represent about 50% of the page views.
- jedberg 16y agoThe database is rarely accessed in request. Almost all DB access comes from batch processes.