๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

eager loading1

N+1 ๋ฌธ์ œ์™€ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• N+1 ๋ฌธ์ œ๋ž€?N+1 ๋ฌธ์ œ๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์™€ ๊ด€๋ จ๋œ ์„ฑ๋Šฅ ๋ฌธ์ œ๋กœ, ์ฃผ๋กœ ORMs(Object-Relational Mapping)์—์„œ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค.์ด๋Š” ํ•œ ๋ฒˆ์˜ ์ฟผ๋ฆฌ๋กœ ์ถฉ๋ถ„ํžˆ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ์Œ์—๋„ ๋ถˆ๊ตฌํ•˜๊ณ , ์ถ”๊ฐ€์ ์ธ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ ธ์˜ค๊ธฐ ์œ„ํ•ด N๊ฐœ์˜ ์ถ”๊ฐ€ ์ฟผ๋ฆฌ๊ฐ€ ์‹คํ–‰๋˜๋Š” ์ƒํ™ฉ์„ ๋งํ•ฉ๋‹ˆ๋‹ค.์ด๋กœ ์ธํ•ด ์„ฑ๋Šฅ์ด ์ €ํ•˜๋˜๊ณ , ํŠนํžˆ ๋ฐ์ดํ„ฐ๊ฐ€ ๋งŽ์•„์งˆ์ˆ˜๋ก ์‹ฌ๊ฐํ•œ ๋ณ‘๋ชฉํ˜„์ƒ์„ ์ผ์œผํ‚ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.  N+1 ๋ฌธ์ œ์˜ ์˜ˆ์‹œ์ƒํ™ฉ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๋‘ ๊ฐœ์˜ ํ…Œ์ด๋ธ”์ด ์žˆ๋‹ค๊ณ  ๊ฐ€์ •ํ•ฉ๋‹ˆ๋‹ค.Author ํ…Œ์ด๋ธ”idname1John Doe2Jane SmithBook ํ…Œ์ด๋ธ”idtitleauthor_id1Book A12Book B13Book C2 ์ฝ”๋“œ ์˜ˆ์‹œ (Python + SQLAlchemy)from sqlalchemy.orm import joinedl.. 2024. 12. 11.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”