Hacker News new | ask | show | jobs
by radialapps 823 days ago
It uses very complex hand optimized SQL queries to do everything in a single database query. The database is also structured in a way to support this.

The result: each request overall only takes a few milliseconds for the hardest part, the rest of the optimization is a game of caching.