Re: Contain and SQL Statement Question

Pagination?

Jeremy Burns
Class Outfit

jeremyburns@classoutfit.com
http://www.classoutfit.com

On 31 Mar 2011, at 13:01, heohni wrote:

> 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

--
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