jpa-patterns

To fix the N+1 problem in Spring Data JPA, apply fetch joins and DTO projections to optimize lazy loading. This Skill provides patterns for selecting the correct loading strategy and query structure to avoid oversized results and redundant database calls.

Designing JPA entities requires lean structures with clear ownership and sensible defaults. This Skill provides guidelines for building auditable entities, defining reliable relationships, and establishing indexing strategies to prevent common Hibernate performance issues.

Handling JPA pagination and transactional boundaries requires proper transaction propagation and query limits. This Skill specifies practical requirements for transactional boundaries, batching, and scalable read paths to manage large datasets efficiently.

Yes, this Skill covers auditing and safe migrations for Hibernate. It specifies patterns for consistent entity auditing and safe schema migrations, ensuring your Spring Boot data access layer remains scalable and maintainable during domain model evolution.

Use lazy loading to prevent fetching unnecessary data and eager loading only when associations are always needed. This Skill helps you review entities and queries to balance loading strategies, applying fetch joins and projections to ensure scalable reads.