Hi all.

For me Hibernate bring chance to use more OO design ability. But we still use relational database. It is often a "domain object model" must be shoehorned onto a relational database.
For me it is like a trade off OO design or plain table. And in real world can’t find that many experts can help me in all aspects.
Just wonder if people can share the experience, that’s on what kinds factors will affect performance and how much, just roughly.
Like if my query is going cross 20 classes. So when I do mapping, I need remodel to 10, then performance increase 3 times. And those 20 have 5 main classes, which may have 10000 records each.
I know that will be too many factors. But still want to know some real number, from other people.
Most wanted is how many joined-table will really start to effect performance.

Thanks

Are you under the impression that Hibernate doesn't work w/ a relational database?

SQL Tuning, Dan Tow, O'Reilly

Thanks for reply. My English is bad, What I like to know, it is more statistical.

More like "People in here is smart, maybe they have 160 IQ, but what is normal people's IQ?"