What do you mean? On 31 Mrz., 14:03, Jeremy Burns | Class Outfit <[email protected]> wrote: > Pagination? > > Jeremy Burns > Class Outfit > > [email protected]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 <[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.organdhelp > >>> 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 > > 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
