Why is the Hibernate query.list() slow?

by

I am not 100% certain on this answer, since tuning / optimization issues are always so difficult to pinpoint.

However, based on the fact that you turned on show_sql, extracted the query, and ran it directly against the database and saw sub-second results vs execution time through Hibernate Query, I am focusing on the manner in which Hibernate is constructing and hydrating objects that result from the query.list() call.

Here is another user who mentioned similar Query performance issues in Hibernate, and saw dramatic performance increases by adding full convenience constructors (constructors that accept a value for each field) in the POJO: Simple hibernate query returning very slowly

It sounds like they stumbled upon this fix, and there was not a clear understanding of why this worked. There was speculation regarding Hibernate having to use reflection to detect properties. I am curious myself and am planning to dig into the source code for Hibernate to better understand this when I have a chance. In the meantime, though, you may wish to look into adding these full constructors with parameters for all of your POJO class attributes and see if that makes a difference.

Please do let me know what you find, as I am very interested in Hibernate performance optimization. Thanks!

More Related Contents:

  1. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  2. How to map an entity field whose name is a reserved word in JPA
  3. What’s the difference between JPA and Hibernate? [closed]
  4. How to convert a Hibernate proxy to a real entity object
  5. What is the solution for the N+1 issue in JPA and Hibernate?
  6. JPA CascadeType.ALL does not delete orphans
  7. Wrong ordering in generated table in jpa
  8. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  9. Hibernate criteria: Joining table without a mapped association
  10. what is @JoinColumn and how it is used in Hibernate
  11. JPA eager fetch does not join
  12. In which case do you use the JPA @JoinTable annotation?
  13. How can I get the session object if I have the entity-manager?
  14. Hibernate: flush() and commit()
  15. Apache Commons equals/hashCode builder [closed]
  16. Hibernate/persistence without @Id
  17. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  18. Hibernate Criteria Query to get specific columns
  19. Disable the log from specific class/jar via logback.xml
  20. IN-clause in HQL or Java Persistence Query Language
  21. How to set the timeout period on a JPA EntityManager query
  22. Persist collection of interface using Hibernate
  23. Configure hibernate to connect to database via JNDI Datasource
  24. What is the MariaDB dialect class name for Hibernate?
  25. compatibility of spring 4.0.0 with hibernate 4.30 [duplicate]
  26. org.hibernate.InstantiationException: No default constructor for entity: : principal.Cliente
  27. Unsuccessful: alter table XXX drop constraint YYY in Hibernate/JPA/HSQLDB standalone
  28. Using hibernate criteria, is there a way to escape special characters?
  29. How do I map a BigDecimal in Hibernate so I get back the same scale I put in?
  30. Create session factory in Hibernate 4

Leave a Comment