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