Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate Performance for CRITERIA / SELECT Queries..

 
Shridhar. Blr.
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

How is the Performance of Hibernate for "SELECT" Queries..

I am just interested in fetching the data from the SQL & create an xml from the resultset..
The table may have large number of records..
I have multiple tables, from where i wanna do this..

Is it better to go with normal JDBC SELECT queries or Hibernate Criteria is good..


Thanks,
/Shridhar..
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Performance of queries (whether they be HQL or SQL) will be very particular to your environment an the data in your database. Ultimately, Hibernate just uses SQL anyway, so the query speeds should be pretty comparable. Try it and see.
[ May 04, 2006: Message edited by: Paul Sturrock ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic