Spring Data JPA: Non-Obvious Performance Issues

Why the service layer should return an Entity, not a DTO. Why fetching small collections can lead to million-dollar datasets. Is it worth fetching deep-nested entities. How turning off autocommit can dramatically increase application throughput.