browse/
2 results
databases/the-n-1-query-problem-why-a-page-that-asks-the-database-501-questions.md
The N+1 query problem: why a page that asks the database 501 questions is slow
A page that lists authors and their books can quietly send one query per author. With 500 authors that is 501 trips to the database, and…
databases/sql-joins-how-two-tables-become-one-answer-inner-left-right-full.md
SQL JOINs: how two tables become one answer (INNER, LEFT, RIGHT, FULL)
Your data lives in two tables, but your question needs both. A JOIN lines them up, and the four kinds (INNER, LEFT, RIGHT, FULL) differ…