I have a quick question regarding Hibernate querying. We just started using Hibernate on our project. Our application is web based and has tons of table listings. On checking the sql generated by hibernate I was perplexed to find that for a HQL query such as “from Site”, multiple queries are run; first one to get the ID’s and a query for each row. Am I doing something wrong or is this the default behavior of Hibernate. We have a high traffic site with so many queries per page we will not be scalable. Any suggestions will be appreciated.

are you using .list()?

see http://forum.hibernate.org/viewtopic.php?t=943979