Get the latest tech news

Short-Circuiting Correlated Subqueries in SQLite


Skipping expensive per-row subqueries to speed up my average query ~17%.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of SQLite

SQLite

Related news:

News photo

100k TPS over a billion rows: the unreasonable effectiveness of SQLite

News photo

Ultra efficient vector extension for SQLite

News photo

What if we treated Postgres like SQLite?