Hi,

I had a simple query like "from Person" to get all people. Person has a many-to-many relationship with Category, and it has a set of the categories it is belong to. There is no other relationship of Person. So database is simply a person, category person_category tables.

Performing such query with hibernate takes a very long time (3x or 4x slower) comparing to native sql call via JDBC. I simply query all people and categories they belong to and create the same objects as hibernate does. Do I need to do something else with hibernate ? I had a simple configuration with connection pooling. I know ORM is slower and it is quite normal, but I dont know how slow it is, so I could not know if my code or configurations are wrong or it is just the way it is...

Thanks in advance.

Mete

Perhaps you would want to do join fetching to get better performance:

List l = hibernateSes.find("from Person as p join fetch p.categories");