Skip to content

Instantly share code, notes, and snippets.

@AoiYamada

AoiYamada/n+1.sql

Last active April 4, 2021 13:02
Show Gist options
  • Save AoiYamada/1d8880d03727e11a62b541663268ad57 to your computer and use it in GitHub Desktop.
Save AoiYamada/1d8880d03727e11a62b541663268ad57 to your computer and use it in GitHub Desktop.
Download ZIP
N + 1 Problems
Raw
n+1.sql
SELECT * FROM singers LIMIT 5;
SELECT * FROM songs WHERE singer_id = 1;
SELECT * FROM songs WHERE singer_id = 2;
SELECT * FROM songs WHERE singer_id = 3;
SELECT * FROM songs WHERE singer_id = 4;
SELECT * FROM songs WHERE singer_id = 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment