if there is that much data why not lazy load the tree view as well with ajax? this would drastically reduce the query complexity, each being a Get<Type>(id).Children type query. other than that you may need to run 3 queries and manually assembly the graph.
On Jul 16, 1:06 pm, "[email protected]" <[email protected]> wrote: > Hello, > > I have a model as follows > > Job -->> Task -->> Schedule > > Job HasMany Task > Task HasMany Schedule. > > I need to display all the information in a tree view manner. But it is > instead a very large object and > if I do Job.FindAll() it executes so many queries and makes my > application poor in performance.. > (Lazy loading is enabled) > > My question is, using Active Record how can I get the entery object > graph in one single query..? > > As always, thanks cuz you always help!! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
