Cộng đồng Hỏi & Đáp của Inflearn

countQuery는 count할 때,  쿼리 최적화를 위해서 하는 걸로  알고 있는데 

 

public Page<MemberTeamDto> searchPageComplex(MemberSearchCondition condition, Pageable pageable) {

List<MemberTeamDto> content = queryFactory

.select(new QMemberTeamDto(member.id.as("memberId"), member.username.as("memberName"), member.age, team.id.as("teamId"), team.name.as("teamName"))) .from(member) .leftJoin(member.team, team)

.where(member.username.eq(condition.getUsername()), team.name.eq(condition.getTeamName()), member.age.goe(condition.getAgeGoe()), member.age.loe(condition.getAgeLoe()))

.offset(pageable.getOffset()) .limit(pageable.getPageSize()) .fetch();

 

JPAQuery<Member> countQuery = queryFactory .selectFrom(member) .leftJoin(member.team, team) .where(member.username.eq(condition.getUsername()), team.name.eq(condition.getTeamName()), member.age.goe(condition.getAgeGoe()), member.age.loe(condition.getAgeLoe()));

return PageableExecutionUtils.getPage(content, pageable, () -> countQuery.fetchCount()); }

 

어차피 실행될 

List<MemberDto> content = queryFactory.select(..생략..

에다가

long count = content.size();  하면 

count가 나오지만

위처럼 굳이 countQuery를 짜서 쓰는 건

PageableExecutionUtils.getPage(content, pageable, () -> countQuery.fetchCount());

오직 이 기능 때문인가요 ?