Hi


What is the best approch in hibernate when a query is going to give 1000 objects in a result set? Executing this query takes a lot of time.

Thanks
Yogs

the best way is to have the best mapping and only retrieve the part a the graph you need.

1st: use .list() instead of .iterate()
2nd: use lazy=true for to-many relations if you don't need the lists to be loaded
3rd: use proxy (and outer-join=false) for to-one relation to block the load of your object graph


and before all this
read the doc and of course the part that deals with performance....

number of sql queries generated can show you if your mapping is optimized for your issue (but that's not always so easy to see)

good luck