I've been trying to get NHibernate into development for a project I'm working on at my workplace.
Since I have to put a strong emphasis on performance, I've been running a proof-of-concept stress test on an existing project's table with thousands of records, all of which contain a large text column.
However, when selecting a collection of these records, the select statement takes a relatively long time to execute; apparently due to the aforementioned column.
The first solution that comes to mind is setting this property as lazy:
<property name="Content" lazy="true"/>
But there seems to be no difference in the SQL generated by NHibernate. My question is, how do lazy properties behave in NHibernate? Is there some kind of type limitations I could be missing? Should I take a different approach altogether?
Using HQL's new Class(column1, column2) approach works, but lazy properties sounds like a simpler solution.
It's perhaps worth mentioning I'm using NHibernate 2.1.2GA with the Castle DynamicProxy.
Thanks!
