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..

If you want to use SQL then use JDBC Selects.

If you want to put some effort into using Hibernate to abstract away the SQL for relationships, then use hibernate. With hibernate you will replace the selects with calls to get inside of objects, but you will need to spend the time to map your database schema into hibernates XML files in order to do so.