Hi, Just a simple problem, I have one central table (model) that has a lot of relationships with other tables. The problem is, for one view I need to get 3 levels of hierarchy (recursive) to be able to get to specific data, but only for one specific direction. Since the table is connected to 5 other tables, Cake tries to fetch 3 levels of hierarchy in all the directions causing major overhead. I know that I can cut loose some associations, but this is not the way since I do need the other data be it in not so many levels of hierarchy.
Now I came up with a possible solution but I thought there could be some more acceptable way in achieving this: - just findAll() using 1/2 levels of hierarchy and query the remaning information. - Also I was wondering if there is some way to include the fields that need to be fetched for certain relationships, when a book is connected to an author, when querying all the books I might only be interested in the author's name and not in the address (for instance) Any help on this in really appreciated. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
