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