jpa-hibernate-optimization
Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
소스 정보
- 저장소
- Hack23/cia
- 최근 소스 활동
- 2026년 2월 1일 00:05
- 감지된 SKILL.md 언어
- 영어
- 스타
- 239
- 포크
- 57
설치 방법
기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.
소스 파일 검토
설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.
SKILL.md 표시 중
SKILL.md
소스 지침 · 읽기 전용 미리보기- name
- jpa-hibernate-optimization
- description
- Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
# JPA/Hibernate Optimization Skill
## Purpose
Optimize database access with proper entity design, query optimization, and caching.
## When to Use
- ✅ Designing entity relationships
- ✅ Optimizing slow queries
- ✅ Preventing N+1 queries
- ✅ Implementing caching
## Entity Optimization
```java
@Entity
@Table(name = "politician", indexes = {
@Index(name = "idx_politician_party", columnList = "party"),
@Index(name = "idx_politician_district", columnList = "district")
})
@Cacheable
@org.hibernate.annotations.Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
public class Politician {
@Id
private String id;
@Column(name = "first_name", nullable = false, length = 50)
private String firstName;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "party_id")
private Party party;
@OneToMany(mappedBy = "politician", cascade = CascadeType.ALL, orphanRemoval = true)
@BatchSize(size = 20)
private List<VotingRecord> votingRecords;
}
```
## Query Optimization
```java
// Use JOIN FETCH to prevent N+1
@Query("SELECT p FROM Politician p JOIN FETCH p.party WHERE p.district = :district")
List<Politician> findByDistrictWithParty(@Param("district") String district);
// Use DTOs for read-only queries
@Query("SELECT new com.hack23.cia.dto.PoliticianSummary(p.id, p.firstName, p.lastName) " +
"FROM Politician p WHERE p.active = true")
List<PoliticianSummary> findActivePoliticiansSummary();
// Pagination for large result sets
Page<Politician> findByParty(String party, Pageable pageable);
```
## Second-Level Cache
```yaml
spring:
jpa:
properties:
hibernate:
cache:
use_second_level_cache: true
region:
factory_class: org.hibernate.cache.jcache.JCacheRegionFactory
javax:
cache:
provider: org.ehcache.jsr107.EhcacheCachingProvider
```
## References
- Hibernate: https://hibernate.org/
- DATA_MODEL.md
GitHub에서 보기