NHibernate version: v2.0.50727
Name and version of the database: SQL Server 2005


Hello friends,
I am facing performance issue with lazy loading.
Here is scenario:
I had a table "Work" with around 100 fields. I have setup 5 "many-to-one" for which foreign key doesn't exist in database (which should be but bad database design!!). 1 "many-to-one" relationship with itself (self reference).
"Work" table has around 15000 entries.

When I load mentioned 5 "many-to-one" relationships lazily, it takes considerably more time. I takes less time (10 time less) when I set lazy="false" in HBM. Memory usage is also too much in lazy loading (takes 500 MB)

These 5 tables have also around 50 to 70 columns.

May creating of proxy put more overhead than actually retrieving objects?
(actual retrieval is done through "select" on each table.. no join).

Please guide.

Thanks in advanced,

- Yogendrasinh

Please, can you send a test case to reproduce this ?

Thanks.

Do the relations actually get fetched? If Yes, this behavior is to be expected. one Join should be way faster then thousands of selects.

For determination what really is going on include the sql-logging of hibernate along with the code snippet