TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

What database structure powers News.YCombinator efficiency?

7 pointsby CalmQuietabout 16 years ago
As database web-dev newbie (or at least elementary level), I'm trying to get up to speed on optimization issues for my growing rdbms.<p>I learn a lot from studying examples, and I'm really impressed with the speed of HN's performance / data freshness. Has there been a HN post that describes the HN-news database structure behind its burgeoning service? [ I tried some search within site and via searchyc, but general terms like "database structure" yield way too much, and I've not known what terms would helpfully narrow search. ] Thanks!

2 comments

davidwabout 16 years ago
This has some information about it:<p><a href="http://en.wikipedia.org/wiki/DRAM" rel="nofollow">http://en.wikipedia.org/wiki/DRAM</a>
评论 #494293 未加载
allenbrunsonabout 16 years ago
pg prefers to avoid databases where possible. viaweb stored all its information in flat files, and so does hacker news.
评论 #495292 未加载
评论 #494299 未加载