<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">맴버 : 팀 양쪽다 LAZY 로딩으로 설정해놓고</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">(다) : (일)</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">member1, member2 가 teaA, teamB 를 각각 연관관계를 맺는다고 가정하고</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">List&lt;Member&gt; result = em.createQuery(select m from Member m , Member.class).getResultList()</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">를한다면 맴버에대한 값만 반환이 될것이고.</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">이 반환된 값 result 를이용해서 Team에대한 필드정보를 가져오는 쿼리를 한다면 , 여기서 N+1 이 발생하는건가요?~</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">질문의 요점은 다대일, LAZY도 N+1이 발생할수 있는냐 입니당~</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">.</div>

<p><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. {질문자}님, 공식 서포터즈 {답변자}입니다.\n{내용}\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:15,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:22}" data-sheets-hyperlinkruns="{&quot;1&quot;:15,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:22}" style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt;">안녕하세요.&nbsp;</span></span><span style="font-family: Arial;">dhdh9224@gmail.com</span><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. {질문자}님, 공식 서포터즈 {답변자}입니다.\n{내용}\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:15,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:22}" data-sheets-hyperlinkruns="{&quot;1&quot;:15,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:22}" style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt;">님, </span><span style="font-size: 12pt; text-decoration-line: underline; text-decoration-skip-ink: none; color: #1155cc;"><a class="in-cell-link" href="https://www.inflearn.com/blogs/617" target="_blank" rel="noopener noreferrer">공식 서포터즈</a></span><span style="font-size: 12pt;"> David입니다.<br />.</span></span></p>
<p><span style="font-family: Arial;">동일하게 발생합니다.</span></p>
<p><span style="font-family: Arial;">회원을 조회하는 쿼리가 한 번 나갈 것이고 (1)</span></p>
<p><span style="font-family: Arial;">회원을 조회하는 쿼리의 결과가 N이라면</span></p>
<p><span style="font-family: Arial;">회원이 가진 Team에 대한 접근이 발생할 때 N번의 조회쿼리가 나갈 것입니다.</span></p>
<p><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. {질문자}님, 공식 서포터즈 {답변자}입니다.\n{내용}\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:15,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:22}" data-sheets-hyperlinkruns="{&quot;1&quot;:15,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:22}" style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt;">.<br />감사합니다.</span></span></p>

Inflearn Community Q&A

뻥튀기 N+1 에관하여 궁금한점..