jpa-n1-query-detectorlisted

# JPA N+1 Query Detector ## Core Principles 1. **Hibernate Fetches**: Avoid lazy-loading relationships within loops or stream operations. 2. **Batch Fetching & Joins**: Resolve N+1 issues by using `@EntityGraph` or `JOIN FETCH` inside custom JPQL queries. 3. **Hibernate Statistics**: Enable Hibernate statistics in development to verify query counts. ## Remediation Patterns ### Ineffective Pattern (Triggers N+1 queries) ```kotlin val users = userRepository.findAll() for (user in users) { println(user.posts.size) // Post is loaded lazily for each user } ``` ### Remediation A: Using JOIN FETCH ```kotlin @Query("SELECT u FROM User u LEFT JOIN FETCH u.posts") fun findAllWithPosts(): List<User> ``` ### Remediation B: Using @EntityGraph ```kotlin @EntityGraph(attributePaths = ["posts"]) override fun findAll(): List<User> ```