Hi,
Everytime
that the Hibernate team says that Hibernate is "oh so cool", and "it produces oh
so optimized SQL" and "its oh so fast", I usually concur. However, I have often
have this lingering, nagging feeling in my mind as to "well, how optimal can an
ORM-based solution *really* be versus custom JDBC or BMP".
Until
now.
I've been
profiling my application (both Java and SQL) code extensively, and I've realized
that any bottlenecks that I may have are not really in the data access code.
Furthermore, after spending some time optimizing Hibernate queries and
associations, I've to tell you that most of the time, I can't think of better
custom (portable) SQL that I could have written.
Amazing.
Sigh. Wish everything was this good.
Thanks
folks!
Sandeep.
