Hello,

Using Hibernate Version 3.3.0. I have a general query about the performance of the internal workings of a simple hibernate select statement

I have got a simple query which I have mapped within the orm.xml file which hits the DB and gets around 10 rows...I run the same test case twice in a loop...While the first iteration took around 450 ms , the second took only around 26 ms...Turning on profiling and logging I was able to figure out that the the follwing three methods in the first iteration took the majority of the time

Loader.prepareQueryStatement()
Loader.getResultSet() and
Loader.getRowFromResultSet() while during the second iteration, the three same methods had a drastic drop in time taken....

Since I have mapped the query in the orm.xml file, I presume the query plan is not executed even for the the first iteration...Could someone pls shed some light on this...It would be quite useful

Thanks...Vijay

well you'll have to show some code. Microbenchmarks are not really reliable.