On 11/5/07, Claudia <[EMAIL PROTECTED]> wrote: > b) The query is really inefficient: Example: If the first query > returns 10 results we need 21 queries for in total (the join query and > then 10 queries each for model2 and model3). We could get the same > result by having only one query which uses a left join for joining > model1 and model2 and another left join for joining model2 and model3.
Why is that a problem? Are you already suffering from performance problems? Or do you think you *might* have a performance problem? Or you might consider 21 queries not so "nice". First make it work, then make it faster. You can always revert to a custom finder query if you happen to experience problems with the amount of queries. Martin -- Martin Schapendonk, [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
