interface UserRepo extends JpaRepository<User, Long>, JpaSpecificationExecutor<User> {} // Usage Specification<User> spec = (root, query, cb) -> List<Predicate> predicates = new ArrayList<>(); if (name != null) predicates.add(cb.equal(root.get("name"), name)); if (minAge != null) predicates.add(cb.greaterThan(root.get("age"), minAge)); return cb.and(predicates.toArray(new Predicate[0])); ; List<User> result = userRepo.findAll(spec, PageRequest.of(0, 10)); | Practice | Why | |----------|-----| | Prefer Pageable over List for large results | Memory & DB load | | Use @EntityGraph for eager fetching | Avoid N+1 queries | | Avoid @ManyToOne(fetch = EAGER) at mapping level | Global impact too broad | | @Transactional(readOnly = true) on query methods | DB optimization | | Batch writes with saveAll() | Reduce round trips | | Use projections instead of full entities | Less data transfer | Example projection: interface UserSummary String getFirstName(); String getLastName();
I notice you're asking for a "deep guide" related to a specific PDF: Spring Data (Packt) — but you've also added "spring data packt .pdf checked." spring data spring data packt .pdf checked
Example: