Hi,
I found out by setting show_sql = true, that in my app at least, hibernate will always parse consecutive hql queries from scratch, each time they are run. I assume that because each time, i see the same sql generated but with different aliases. Unfortunately, this means that the underlying rdbms cannot cache those queries and therefore we cannot benefit from such performance improvement.
From what i know hibernate uses prepared statements under the hood. Therefore, i was expecting to see the same sql output each time the same hql query was run. Has anyone come across this issue? Can anyone suggest something that i can do about it?
Cheers!
Lefteris
|