2023-01-01T11:45:44.264Z

0

자료에 forCounting 옵션을 넣으신 이유가 Pageable을 사용할 경우, 조회 쿼리와 Count쿼리를 구분해서 힌트를 적용할 수 있다는 말씀이시군요?

readOnly를 count쿼리에 적용하지 않을 때 더티체킹 하는것을 어떻게 확인하지? 라는 생각에 이해가 잘 안되었던것 같습니다.
( 일차원적으로 생각하는 성향이 있는듯합니다.. ㅠㅠ )

Comment 힌트를 넣어서 확인해보니 이해하기 쉬웠습니다.

application.yml ( use_sql_comments 옵션 추가 )

spring.jpa.hibernate.properties.hibernate.use_sql_comments: true

MemberRepository

@QueryHints(value = @QueryHint(name = "org.hibernate.comment", value = "memberRepository.findByUsername"), forCounting = false)
Page<Member> findByUsername(String name, Pageable pageable);

MemberRepositoryTest

@Test
void queryHint() {
    //given
    memberRepository.save(new Member("member1", 10));
    memberRepository.save(new Member("member1", 20));
    memberRepository.save(new Member("member1", 30));
    memberRepository.save(new Member("member1", 40));
    em.flush();
    em.clear();

    //when
    PageRequest pageRequest = PageRequest.of(0, 3, Sort.by(Sort.Direction.DESC, "username"));
    Page<Member> memberPage = memberRepository.findByUsername("member1", pageRequest);
}

로그

forCounting = false

/* select count(generatedAlias0) from Member as generatedAlias0 where generatedAlias0.username=:param0 */
select count(member0_.member_id) as col_0_0_ from member member0_ where member0_.username='member1';

forCounting = true

/* memberRepository.findByUsername */ select count(member0_.member_id) as col_0_0_ from member member0_ where member0_.username='member1';

새해 복 많이 받으세요.^^ OTL..

0

결과도 공유해주셔서 감사합니다^^ 새해 복 많이 받으세요.