hi all,
is there a way to optimize a read only query?

i've already define mutable=false in my mapping

does
query.setLockMode(alias,NONE) or query.setLockMode(alias,READ) optimize the query? If yes, which is the best?

I know about cache... but i want to optimize the query, i've optimized the outer join and lazy features thanks to Gavin... but i want to know if there are more things we can do.

I remember an old VB app, we were able to use a READONLY recordset, and using it, the time of execution of the query was very short.


Thanks,
Anthony

Anthony, have you tried to set up a read-only 2nd-level cache yet? Check out chapter 12.2 at http://www.hibernate.org/hib_docs/reference/html/performance.html .
Scott

I gave some advice on this topic in the thread: http://forum.hibernate.org/viewtopic.php?t=409&highlight=