Joined: Fri Jul 10, 2009 2:53 pm Posts: 1
|
I recently invested in NHProfiler to troubleshoot why my application was taking so long to load. I have learned that many of my queries to the DB are N+1 and there are a ton of them.
I am using HQL to load most of my objects, not ICriteria. It's been difficult to find out how to get around this.
I am using Lazy Loading and just tried enabling second level caching. I haven't seen a reduction in calls and it's very costly.
Can anyone point me in the right direction? your help is greatly appreciated.
|
|