Hello il would like to optimize my queries with subselect fetch.

this declaration didn't work

<many-to-one name="*" class="*" fetch="subselect">

And i don't like to use join fetch

Example
Person --> many-to-one --> Adress


When you select n Persons (1 select) and get Adress for Each Person (n Select)

for 50 Persons got 51 queries

with subselect

select many Person (1 select) and on first access of property Adress (1 select)

for 50 Persons got 2 queries

Thanks

Pioug,

I believe you have to specify the fetching strategy on the "one" side of a collection definition, not on the "many-to-one" side.