Hi guys

I have a Parent and Child with a one-to-many uni-directional relationship. When I try to get all the Parent with a Child of a certain criteria (say age=8). I have a n+1 selection problem.

Hibernate will first look into the Child table to get all Parent id who got a child age=8. And then it will do a select for all the Parent Id it retrieved in the above select.

Is there anyway to improve the performance? How to prevent this n+1 selection from happening?

Thanks!

I think hibernate does a join. But there's no way to get around having to look at each child to see if it's got an age = 8.