Hi,

I need to achieve better performance when loading objects using NHibernate.

Here is the case:
Objects of type Class1 need to be loaded. Just load all of them. This class has a many-to-one relation with Class2:

<many-to-one name="Cl2"
class="Class2"
column="Class2ID" cascade="none" />

There are a few objects of Class1 and they are quite simple. When there are not many objects of Class2 in the database, the loading is fast. But when they are more than 1000 (actually even more are needed) the loading takes about 4-5 minutes. That's really not acceptable :).

Please, help me with the solution of this.

Hi,

Can you post the code you are using to load the objects?

Is it possible that you are running into the classic SELECT N+1 problem? (http://www.ayende.com/Blog/archive/7627.aspx)

Regards,
Richard