Jpa Hibernate Optimization

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

@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;
}