This issue has been asked before, but with no answer ("query issued for each not-found instance").

When using the not-found=ignore attribute in a one-to-many/many-to-many, NHibernate is issuing a query for every element not found in the collection, even when using an outer join.

In some cases this causes a significant performance overhead.

Any thoughts?