👀 Views: 0 💬 Answers: 1 📅 Created: 2025-08-06

java spring-boot jpa hibernate performance Java

I'm refactoring my project and I'm getting frustrated with I've searched everywhere and can't find a clear answer... I'm working on a project and hit a roadblock... I'm experiencing significant performance issues while fetching large datasets using Spring Boot with JPA in a Java 17 application. My entity class looks like this: ```java @Entity public class Product { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; private BigDecimal price; // Other fields, getters, and setters } ``` I have a repository method like the following to fetch products: ```java public interface ProductRepository extends JpaRepository<Product, Long> { List<Product> findAll(); } ``` When I call `productRepository.findAll()`, the application takes a long time to respond, especially when the database contains over 10,000 records. I've tried using pagination to limit the number of returned records: ```java Page<Product> findAll(Pageable pageable); ``` However, even with pagination, the performance is not optimal, and the first page still takes about 4-5 seconds to load. I have also enabled caching in my application: ```yaml spring: cache: type: simple ``` Despite this, I noticed that the cache is not being utilized as expected. I checked the SQL logs and saw that the select query is executed every time, which leads me to believe that the caching is not configured correctly. I'm also using Hibernate as my JPA provider, and I've set the following properties in `application.properties`: ```properties spring.jpa.hibernate.ddl-auto=update spring.jpa.show-sql=true spring.jpa.properties.hibernate.jdbc.batch_size=50 ``` I want to improve the performance of my data fetching strategy. Is there a better way to optimize data retrieval in this scenario? Could there be any issues with my current caching strategy or Hibernate configurations? Any suggestions would be greatly appreciated. For context: I'm using Java on macOS. How would you solve this? What's the best practice here? I'm developing on Ubuntu 22.04 with Java. What's the correct way to implement this? Is there a simpler solution I'm overlooking? I'm working with Java in a Docker container on CentOS. Has anyone else encountered this?