Short-Circuiting Correlated Subqueries in SQLite
Evan Schwartz
Short-Circuiting Correlated Subqueries in SQLite
Skipping expensive per-row subqueries to speed up my average query ~17%.
 #ycombinator