Hi Mauricio,
Thanx for your reply.
I've read the sites you provided, but the problem with these examples
is that they all are about retrieving one record, they always provide
an ID.
My problem is that I want all the case-objects, not just one. I think
there's nothing left to do than to use
It seems you are interested in lazy loading, right?
For example, if Steps is lazily loaded, you can do Case.FindAll()
without having them loaded unless you access Case.Steps.
http://castleproject.org/activerecord/documentation/trunk/advanced/tuning.html#lazyload
*can* you do it in one query, yes. however you will run into other
issues beside the quantity of queries.
1. loading all the case + steps + sub-steps + elements + author +
organization is 1 big mess.
2. distinct entities, since your using lists and not sets.
you will need to work with the
Hi,
I'm using ActiveRecords for several projects, and always find it very
pleasant te work with.
Currently i'm using it for a bigger project, and I begin to get
performance issues, mainly because I think I'm having to many selects.
The problem is, that I cannot use Lazy Loading, because I'm
Try a multiquery or multicriteria where each query fetches one of the
collections you need. See:
http://nhforge.org/doc/nh/en/index.html#performance-multi-query
http://nhforge.org/doc/nh/en/index.html#performance-multi-criteria