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 <[email protected]> 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 <[email protected]>:
>
>
>
> > 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
> > [email protected] 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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
