there are 2 tables and 2 ValueObjects. customers and orders.

customers
__________
customerID
name
surname
...

orders
______
orderID
FK_customerID
name
price
....

CustomerVO has a collection of OrderVO's.
when writing a method, which retrieves 100 customers which select
method is more appropriate ?

method 1) :
select * from customers c inner join order o on c.customerID =
o.FK_customerID

the result would be something like :

customerID name    orderID price
_________  ____     _____  ____
1                 john      154     200
1                 john      234     300
1                 john      178     355
2                 mike     154     200
2                 mike     433     700

and then in every iteration look if customerID has changed. if so,
construct a new CustomerVO object.

...
int customerID = -1;
while (rs.next()) {
     if (customerID == -1 || rs.getInt("customerID") != customerID) {
          customerVO = new CustomerVO();
          customers.add(customerVO);
          // fill rest of customerVO
     }
     // fill order and put in customer
     OrderVO orderVO = new OrderVO();
     orderVO.setPrice(rs.getDouble("price"));
     customerVO.addOrder(orderVO);
}

method 2)
first retrieve a collection of customers :

select * from customers

then iterate through this collection of customers and get a collection
of orders for every customer.

the second one is much easier to code, but the first one has a much
better performance.

how would Hibernate handle this ?

thanks in advance