Menu
Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/Hack23/cia --skill jpa-hibernate-optimizationThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Showing SKILL.md
Identity and access management: RBAC, least privilege, MFA, quarterly reviews per ISO 27001 A.5.15, A.8.2, A.8.3
Business continuity and disaster recovery: 30-day retention, quarterly restore tests, RTO/RPO targets per ISO 27001 A.17
Political psychology, cognitive biases, group dynamics, leadership analysis, decision-making patterns for Swedish political intelligence
Based on SOC occupation classification
| name | jpa-hibernate-optimization |
| description | Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies |
Optimize database access with proper entity design, query optimization, and caching.
@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;
}
// 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);
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