On 29 mayo, 09:10, "R. Rajesh Jeba Anbiah"
<[EMAIL PROTECTED]> wrote:
> On May 28, 6:29 pm, "Chris Hartjes" <[EMAIL PROTECTED]> wrote:> On 5/28/07,
> R.RajeshJebaAnbiah<[EMAIL PROTECTED]> wrote:
> > > I'm getting so many queries in index action of controller, say for a
> > > typical blog project with categories, comments and tags, I'm getting
> > > so many queries in blogs/index which is having
> > > $this->Blog->recursive = 0;
> > > $this->set('blogs', $this->paginate());
>
> > This is normal behaviour, and is required for Cake's Models to do
> > their associative data mapping magic.
>
> <snip>
>
> FWIW, I do not question the need to run the queries. But, my
> question is that why it can't be optimized. With the better join
> query, we can have a single query that serves the purpose, instead of
> about 60 queries.
Consider what would happen if you had some of your blogs are
associated with a large number (relative to your limit) of tags/
categories/comments. You can't apply a limit to the number of
associated items, but also you can't even know how many results from
your primary table will be returned.
hth,
AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
