Hibernate Criteria API versus JPQL

Question

Which of the two methods are faster especially for over 1 million rows in database? And what is best practice, to use JPQL or Criteria?

Cheers

Boris Pavlović · Accepted Answer · 2013-11-01 15:46:54Z

3

The best practice is to log the SQL statements created by Hibernate and analyse their execution plans for both methods. It's really hard saying which approach would produce more optimized SQL.

answered Nov 1, 2013 at 15:46

Boris Pavlović

64.9k29 gold badges127 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gimby Over a year ago

Indeed. Something like log4jdbc can help a lot there.

MSA Over a year ago

The people have spoken.

Vilgos Mako Over a year ago

Well I did not expect this comment :))

user4090433 · Accepted Answer · 2014-09-29 08:45:07Z

1

Criteria is a more clean way to do it, the output is the same, but as best practive I recommend Criteria.

Criteria Example

answered Sep 29, 2014 at 8:45

user4090433

Collectives™ on Stack Overflow

Hibernate Criteria API versus JPQL

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related