Hacker News new | ask | show | jobs
by greatNespresso 819 days ago
Impressed by the loading speed of pictures, how does that work?
1 comments

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.