1차 쿼리 성능 테스트 #678

jminkkk · 2024-09-22T04:10:13Z

jminkkk
Sep 22, 2024
Maintainer

1차 쿼리 성능 테스트

서비스에서 사용하는 쿼리를 정리
데이터를 10만 생성
쿼리 성능 테스트
쿼리 성능 개선을 위한 인덱스를 설정
서비스에서 사용하는 각 쿼리에서 사용하는 인덱스 설정
서비스에서 사용하는 모든 조회 쿼리와 테이블에 설정한 인덱스 공유되고 있는지 검사
인덱스를 설정할 수 없는 쿼리가 있는 경우, 인덱스를 설정할 수 없는 이유 작성

Auth
- 로그인
- 로그인 상태 체크
Tag
- 회원의 태그 목록 조회
Category
- 카테고리 생성
- 회원의 카테고리 목록 조회
- 카테고리 업데이트
- 카테고리 삭제
Member
- 회원 가입
- 회원 정보 조회
- 사용자명 중복 확인
Template
- 템플릿 생성
- 템플릿 단건 조회
- 템플릿 수정
- 템플릿 삭제
- 템플릿 검색

인증인가 + 회원 (1) - 초롱
카테고리 (1) - 제우스
태그, 템플릿 단건 조회, 삭제 (1) - 켬미
템플릿 생성 + 수정 (1) - 짱수
템플릿 검색 (1) - 몰리

jminkkk · 2024-09-22T12:57:37Z

jminkkk
Sep 22, 2024
Maintainer Author

Auth

회원 1명
쓰레드 10개에서 n번 요청 시

로그인 상태 체크

# MemberJpaRepository.fetchByName

    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

쓰레드당 100건 (총 1,000건)

Total elapsed time: 6647ms
Average elapsed time: 6ms

쓰레드당 1,000건 (총 10,000건)

Total elapsed time: 44284ms
Average elapsed time: 4ms

쓰레드당 5,000건 (총 50,000건)

(실제 요청은 16310개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0ms
Average elapsed time: 0ms

0 replies

jminkkk · 2024-09-22T13:08:36Z

jminkkk
Sep 22, 2024
Maintainer Author

Tag

회원 1명
태그 1000개
카테고리 5개
템플릿 10만개

쓰레드 10개에서 n번 요청 시

회원의 태그 목록 조회

# templateRepository.findByMemberId
    select
        t1_0.id,
        t1_0.category_id,
        t1_0.created_at,
        t1_0.description,
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    where
        t1_0.member_id=?

    select # 카테고리 전체 갯수만큼 나감;; 왜지?
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.id=?

# templateTagRepository.findDistinctByTemplateIn
    select
        distinct tt1_0.tag_id 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?

# TagJpaRepository.fetchById 태그 갯수만큼 실행
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?

쓰레드당 1건 (총 10건)

Total elapsed time: 180003ms
Average elapsed time: 18000ms

쓰레드당 10건 (총 100건)

(실제 요청은 6개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0ms
Average elapsed time: 0ms

쓰레드당 100건 (총 1,000건)

(실제 요청은 5개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0ms
Average elapsed time: 0ms

0 replies

jminkkk · 2024-09-22T13:45:49Z

jminkkk
Sep 22, 2024
Maintainer Author

카테고리

카테고리 생성

# MemberJpaRepository.fetchById

    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

# CategoryJpaRepository.existsByNameAndMember

    select
        c1_0.id 
    from
        category c1_0 
    where
        c1_0.name=? 
        and c1_0.member_id=? 
    limit
        ?

# CategoryRepository.save

    insert 
    into
        category
        (created_at, is_default, member_id, modified_at, name) 
    values
        (?, ?, ?, ?, ?)

쓰레드당 100건 (총 1,000건)

856건 생성

Total elapsed time: 20111ms
Average elapsed time: 20ms

쓰레드당 1,000건 (총 10,000건)

약 8,800건 생성되었고

Total elapsed time: 135380ms
Average elapsed time: 13ms

쓰레드당 5,000건 (총 50,000건)

(실제 요청은 13139개 밖에 안 갔고 11,635개만 저장)

Total elapsed time: 0
Average elapsed time: 0

회원의 카테고리 목록 조회

# MemberJpaRepository.fetchById

    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.id=?

# CategoryJpaRepository.findAllByMemberOrderById

    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.member_id=? 
    order by
        c1_0.id

[카테고리 약 7건 조회]

쓰레드당 100건 (총 1,000건)

Total elapsed time: 11259ms
Average elapsed time: 11ms

쓰레드당 1,000건 (총 10,000건)

Total elapsed time: 88074ms
Average elapsed time: 8ms

쓰레드당 5,000건 (총 50,000건)

(실제 요청은 16314개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0
Average elapsed time: 0

[카테고리 849건 조회]

쓰레드당 100건 (총 1,000건)

Total elapsed time: 56966ms
Average elapsed time: 56ms

쓰레드당 1,000건 (총 10,000건)

(실제 요청은 3669개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0ms
Average elapsed time: 0ms

카테고리 업데이트

# MemberJpaRepository.fetchByName
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

# CategoryJpaRepository.existsByNameAndMember

    select
        c1_0.id 
    from
        category c1_0 
    where
        c1_0.name=? 
        and c1_0.member_id=? 
    limit
        ?

# CategoryJpaRepository.fetchById

    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.id=?

# CategoryController.updateCategory

    update
        category 
    set
        is_default=?,
        member_id=?,
        modified_at=?,
        name=? 
    where
        id=?

쓰레드당 100건 (총 1,000건)

Total elapsed time: 26130ms
Average elapsed time: 26ms

쓰레드당 1,000건 (총 10,000건)

(실제 요청은 8868개 밖에 안 갔고 다 처리 못함)

Total elapsed time: 0ms
Average elapsed time: 0ms

카테고리 삭제

# MemberJpaRepository.fetchByName
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

# CategoryJpaRepository.fetchById

    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.id=?

# TemplateJpaRepository.existsByCategoryId

    select
        t1_0.id 
    from
        template t1_0 
    where
        t1_0.category_id=? 
    limit
        ?

# CategoryRepository.deleteById

    delete 
    from
        category 
    where
        id=?

쓰레드당 100건 (총 1,000건)

Total elapsed time: 21304ms
Average elapsed time: 21ms

쓰레드당 1,000건 (총 10,000건)

Total elapsed time: 125942ms
Average elapsed time: 12ms

쓰레드당 5,000건 (총 50,000건)

(실제 요청은 16314개 밖에 안 갔고 2,524건만 처리)

Total elapsed time: 0
Average elapsed time: 0

0 replies

kyum-q · 2024-09-22T14:41:12Z

kyum-q
Sep 22, 2024
Maintainer

Member

회원 1명
쓰레드 10개에서 n번 요청 시

회원 가입

# MemberJpaRepository.existsByName 

# MemberRepository.save

# CategoryRepository.save

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 22309ms
Average elapsed time: 22ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 239605ms
Average elapsed time: 23ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 5808
Total elapsed time: 0ms
Average elapsed time: 0ms

회원 정보 조회

# MemberJpaRepository.fetchById

    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.id=?

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 35873ms
Average elapsed time: 35ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 379671ms
Average elapsed time: 37ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 15733
Total elapsed time: 0ms
Average elapsed time: 0ms

사용자명 중복 확인

# MemberJpaRepository.existsByName

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 23001ms
Average elapsed time: 23ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 262951ms
Average elapsed time: 26ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 15684
Total elapsed time: 0ms
Average elapsed time: 0ms

0 replies

kyum-q · 2024-09-22T14:56:06Z

kyum-q
Sep 22, 2024
Maintainer

Template

회원 1명
카테고리 10개
태그 200개
템플릿 1만개
 * 10

쓰레드 10개에서 n번 요청 시

템플릿 생성

# MemberJpaRepository.fetchByName
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

# CategoryJpaRepository.fetchById
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.id=?

# TemplateRepository.save
    insert 
    into
        template
        (category_id, created_at, description, member_id, modified_at, title) 
    values
        (?, ?, ?, ?, ?, ?)

# TagJpaRepository.findNameByNamesIn
    select
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.name in (?, ?)

# TagJpaRepository.fetchByName
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.name=?

# TemplateTagRepository.saveAll
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at,
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name,
        t2_0.id,
        t2_0.category_id,
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name,
        t2_0.created_at,
        t2_0.description,
        t2_0.member_id,
        t2_0.modified_at,
        t2_0.title 
    from
        template_tag tt1_0 
    join
        tag t1_0 
            on t1_0.id=tt1_0.tag_id 
    join
        template t2_0 
            on t2_0.id=tt1_0.template_id 
    left join
        category c1_0 
            on c1_0.id=t2_0.category_id 
    where
        (
            tt1_0.tag_id, tt1_0.template_id
        ) in ((?, ?))

# 
    insert 
    into
        template_tag
        (created_at, modified_at, tag_id, template_id) 
    values
        (?, ?, ?, ?)

# SourceCodeJpaRepository.fetchByTemplateAndOrdinal
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.template_id=? 
        and sc1_0.ordinal=?

# ThumbnailRepository.save
    insert 
    into
        thumbnail
        (created_at, modified_at, source_code_id, template_id) 
    values
        (?, ?, ?, ?)

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 100254ms
Average elapsed time: 100ms

쓰레드당 1,000건 (총 10,000건)

100초 제한

Total request count: 9342
Total elapsed time: 0ms
Average elapsed time: 0ms

쓰레드당 5,000건 (총 50,000건)

100초 제한

Total request count: 7020
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 단건 조회

#  TemplateJpaRepository.fetchById
    select
        t1_0.id,
        t1_0.category_id,
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name,
        t1_0.created_at,
        t1_0.description,
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    join
        category c1_0 
            on c1_0.id=t1_0.category_id 
    where
        t1_0.id=?

# TemplateTagJpaRepository.findAllByTemplate
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?

#  SourceCodeJpaRepository.findAllByTemplate
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.template_id=?

#  MemberJpaRepository.fetchByTemplateId
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 56357ms
Average elapsed time: 56ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 399729ms
Average elapsed time: 39ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 15717
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 수정

# MemberJpaRepository.fetchByName 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.name=?

# CategoryJpaRepository.fetchById
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    where
        c1_0.id=?

# TemplateRepository.save
    insert 
    into
        template
        (category_id, created_at, description, member_id, modified_at, title) 
    values
        (?, ?, ?, ?, ?, ?)

# TagJpaRepository.findNameByNamesIn
    select
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.name in (?, ?)

# TagJpaRepository.fetchByName
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.name=?

# TagRepository.saveAll
    insert 
    into
        tag
        (created_at, modified_at, name) 
    values
        (?, ?, ?)

# TemplateTagRepository.saveAll
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at,
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name,
        t2_0.id,
        t2_0.category_id,
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        c1_0.modified_at,
        c1_0.name,
        t2_0.created_at,
        t2_0.description,
        t2_0.member_id,
        t2_0.modified_at,
        t2_0.title 
    from
        template_tag tt1_0 
    join
        tag t1_0 
            on t1_0.id=tt1_0.tag_id 
    join
        template t2_0 
            on t2_0.id=tt1_0.template_id 
    left join
        category c1_0 
            on c1_0.id=t2_0.category_id 
    where
        (
            tt1_0.tag_id, tt1_0.template_id
        ) in ((?, ?))

# SourceCodeRepository.saveAll
    insert 
    into
        source_code
        (content, created_at, filename, modified_at, ordinal, template_id) 
    values
        (?, ?, ?, ?, ?, ?)

# ThumbnailJpaRepository.fetchByTemplate 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?

# SourceCodeJpaRepository.fetchByTemplateAndOrdinal
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.template_id=? 
        and sc1_0.ordinal=?

# ThumbnailRepository.save
    insert 
    into
        thumbnail
        (created_at, modified_at, source_code_id, template_id) 
    values
        (?, ?, ?, ?)

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 138903ms
Average elapsed time: 138ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 1310618ms
Average elapsed time: 131ms

쓰레드당 5,000건 (총 50,000건)

너무 오래 걸려서 최대 100초 기다림

Total request count: 6838
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 삭제

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 84181ms
Average elapsed time: 84ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 787290ms
Average elapsed time: 78ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 29295
Total elapsed time: 0ms
Average elapsed time: 0ms

0 replies

kyum-q · 2024-09-22T15:02:14Z

kyum-q
Sep 22, 2024
Maintainer

Template

회원 1명
태그 1000개
카테고리 5개
템플릿 10만개

쓰레드 10개에서 n번 요청 시

# TemplateJpaRepository.findAll

# TemplateTagJpaRepository.findAllByTemplate

# ThumbnailJpaRepository.fetchByTemplate

# MemberJpaRepository.fetchByTemplateId

하나의 조건 필터

템플릿 검색 : 멤버만

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 481615ms
Average elapsed time: 481ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 5092735ms
Average elapsed time: 509ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 18602
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 검색 : 키워드만

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 2055268ms
Average elapsed time: 2055ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 4631
Total elapsed time: 0ms
Average elapsed time: 0ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 2455
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 검색 : 카테고리만

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 440094ms
Average elapsed time: 440ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 4364771ms
Average elapsed time: 436ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 21914
Total elapsed time: 0ms
Average elapsed time: 0ms

템플릿 검색 : 태그만

쓰레드당 100건 (총 1,000건)

Total request count: 1000
Total elapsed time: 509428ms
Average elapsed time: 509ms

쓰레드당 1,000건 (총 10,000건)

Total request count: 10000
Total elapsed time: 5694119ms
Average elapsed time: 569ms

쓰레드당 5,000건 (총 50,000건)

Total request count: 17571
Total elapsed time: 0ms
Average elapsed time: 0ms

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

1차 쿼리 성능 테스트 #678

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 6 comments

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

1차 쿼리 성능 테스트 #678

jminkkk Sep 22, 2024 Maintainer

1차 쿼리 성능 테스트

Replies: 6 comments

jminkkk Sep 22, 2024 Maintainer Author

Auth

로그인

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

로그인 상태 체크

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

jminkkk Sep 22, 2024 Maintainer Author

Tag

회원의 태그 목록 조회

쓰레드당 1건 (총 10건)

쓰레드당 10건 (총 100건)

쓰레드당 100건 (총 1,000건)

jminkkk Sep 22, 2024 Maintainer Author

카테고리

카테고리 생성

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

회원의 카테고리 목록 조회

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

카테고리 업데이트

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

카테고리 삭제

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

kyum-q Sep 22, 2024 Maintainer

Member

회원 가입

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

회원 정보 조회

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

사용자명 중복 확인

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

kyum-q Sep 22, 2024 Maintainer

Template

템플릿 생성

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

템플릿 단건 조회

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

템플릿 수정

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

템플릿 삭제

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

kyum-q Sep 22, 2024 Maintainer

Template

템플릿 검색 : 멤버만

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

쓰레드당 5,000건 (총 50,000건)

템플릿 검색 : 키워드만

쓰레드당 100건 (총 1,000건)

쓰레드당 1,000건 (총 10,000건)

jminkkk
Sep 22, 2024
Maintainer

jminkkk
Sep 22, 2024
Maintainer Author

jminkkk
Sep 22, 2024
Maintainer Author

jminkkk
Sep 22, 2024
Maintainer Author

kyum-q
Sep 22, 2024
Maintainer

kyum-q
Sep 22, 2024
Maintainer

kyum-q
Sep 22, 2024
Maintainer