Re: Contain and SQL Statement Question

If I use the contain method I am getting an array like:
Array
(
[0] => Array
(
[Member] => Array
(
[id] => 5
)

[Payment] => Array
(
[0] => Array
(
[id] => 3270
[member_id] => 5
)

[1] => Array
(
[id] => 3271
[member_id] => 5
)

[2] => Array
(
[id] => 3272
[member_id] => 5
)

)

)

Which is really perfect for me.
I am just worried about the performance later when the number of
member is raising.

If I do a LEFT JOIN, I get "nicer" statement, but "loosing" the sorted
result, as the array will look like:

Array
(
[0] => Array
(
[Member] => Array
(
[id] => 5
)

[Payment] => Array
(
[id] => 3270 // first payment
)

)
[1] => Array
(
[Member] => Array
(
[id] => 5
)

[Payment] => Array
(
[id] => 3271 // second payment
)

)
etc etc etc...

It can't be the first time, someone need to select that kind of model
assoc?

On 31 Mrz., 13:26, Eugenio <eugenioc...@gmail.com> wrote:
> If you have that kind of need you are having database architecture
> issues... its not a cakephp issue.
>
> Ask yourself how you do that query in plain SQL.
>
> Cheers
>
> 2011/3/31 heohni <heidi.anselstet...@consultingteam.de>:
>
>
>
> > Hi,
>
> > I have the following models:
>
> > Member hasMany Payments
> > Payment belongs to a member
>
> > To get now all members and their payments I do the following
> > statement:
>
> > $this->paginate = array(
> >            'fields' => array(.....),
> >            'conditions' => array(...),
> >            'contain' => array(
> >                'Payment' => array(
> >                    'fields' => array(...),
> >                    'conditions' => array(...)
> >                )
> >             )
> >        );
>
> > So far, the result is correct.
>
> > BUT!
> > The second statement, where all payment are getting selected, that
> > statement looks like:
> > WHERE `Payment`.`member_id` IN (5, 10, 11)
>
> > This is for 3 members fine, but what will happen, if I have 10k
> > members?
>
> > Do I have the chance to get this whole statement done in 1 single
> > statement? To make sure I will not fail in perfomance in the future?
>
> > Please advice!
> > Thanks!!
>
> > --
> > Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php