Re: so many queries--intentional??

2007-05-29 Thread AD7six
On 29 mayo, 10:46, "R. Rajesh Jeba Anbiah" <[EMAIL PROTECTED]> wrote: > On May 29, 12:32 pm, AD7six <[EMAIL PROTECTED]> wrote: > > > On 29 mayo, 09:10, "R. Rajesh Jeba Anbiah" > > > >FWIW, I do not question the need to run the queries. But, my > > > question is that why it can't be optim

Re: so many queries--intentional??

2007-05-29 Thread R. Rajesh Jeba Anbiah
On May 29, 12:32 pm, AD7six <[EMAIL PROTECTED]> wrote: > On 29 mayo, 09:10, "R. Rajesh Jeba Anbiah" > >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 pur

Re: so many queries--intentional??

2007-05-29 Thread wluigi
The most important is that you only ask for what you need and make a good use of $conditions,$fields,$recursive,$limit and bindModel() unbindModel(); On May 29, 9:32 am, AD7six <[EMAIL PROTECTED]> wrote: > On 29 mayo, 09:10, "R. Rajesh Jeba Anbiah" > > > > <[EMAIL PROTECTED]> wrote: > > On May 28

Re: so many queries--intentional??

2007-05-29 Thread AD7six
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 projec

Re: so many queries--intentional??

2007-05-29 Thread R. Rajesh Jeba Anbiah
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/i

Re: so many queries--intentional??

2007-05-28 Thread Chris Hartjes
On 5/28/07, R. Rajesh Jeba Anbiah <[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('

so many queries--intentional??

2007-05-28 Thread R. Rajesh Jeba Anbiah
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()); I see, for the related comments and category