[데이터베이스]JPQL : N + 1 문제, Fetch Join, 주의사항
발생 상황String jpql = "select m from Member m"; List members = em.createQuery(jpql, Member.class) .getResultList(); for (Member member : members) { System.out.println("username = " + member.getUsername() + ", " + "teamName = " + member.getTeam().name()); //회원1, 팀A(SQL) //회원2, 팀A(1차 캐시) //회원3, 팀B(SQL) //회원 100명 -> N + 1 } 최대 N + 1번 Team 조회 쿼리 수행해결 방안- fetch join String jpql = "select m from Member m..
😎 지식/BE-Spring🌐
2023. 7. 11. 09:02