Hibernate version:
3.1.2

Hi, I´m having performance problems in the application, after using a profiler, I find out that it always has to do with CriteriaQuery.list (also when getting a property of a mapped class).
Googling I found that Criteria is less performant than HQL, but I have widely spread Criterias in the system, and the queries are not simple. Thats why I need something to get HQL from a Criteria.

If someone thinks my problem can be anything else? I´ll be thankfull to hear about it.

Thanks.
Mamana from Argentina

The list() method is what causes the query to execute, so it is naturally going to be the slowest part, since that is when the database is being hit. The Criteria really should not be any slower than using HQL, unless for some reason it generates inefficient SQL in a complex scenario. You can turn on Hibernate logging to see what the actual generated SQL looks like.

thanks for you help, but the DB doesnt seem to be the problem, since the mapping was forced fetch everything (no lazy relations). Actualy the profiler shows that there a being less than 1k DB hits against 85 millon calls to CriteriaQuery.list

Thanks anyway

mamana.