Out of interest, what is your debug level? Jeremy Burns Class Outfit
jeremybu...@classoutfit.com http://www.classoutfit.com On 13 Jul 2010, at 10:57, Alex Bovey wrote: > Hi Nick, > > Thanks for the reply. > > Sorry I should have said in my original post - I'm already using Containable > AND setting recursive to -1 in app_model.php. > > But still the selects are incredibly inefficient - a single query to fetch > each individual row?! > > I'm not specifying 'fields' but surely that's not going to mean the > difference between what should be 2 queries at most, and the thousands I'm > ending up with... > > Thanks, > > Alex > > On Tue, Jul 13, 2010 at 9:59 AM, nurvzy <nur...@gmail.com> wrote: > Use a mixture of: > > fields option key (so you're not retrieving data you don't intend to > use), > containable (so you're not selecting associative models and their > fields you don't care about), > and set recursive = -1 in your app_model.php > > The first thing I do whenever I start any new CakePHP project is open > up app_model.php and add actsAs = array('Containable') and recursive = > -1. > > I suggest you take advantage of the containable component. Read about > it here: > http://book.cakephp.org/view/474/Containable > > Hope that helps, > Nick > > On Jul 13, 2:35 am, Alex Bovey <a...@bovey.co.uk> wrote: > > Hi all, > > > > Using Cake 1.2.0.6311 I'm having real problems with the number of SQL > > queries in my app. > > > > For example, I have Enquiry belongsTo User and User hasMany Enquiry. > > > > A simple $this->Enquiry->find('all') results in one query to fetch the > > enquiries, and then a separate query for every single Enquiry to fetch the > > User for that Enquiry. > > > > When I have more complex model relations I'm ending up with over 10,000 SQL > > queries. > > > > What am I doing wrong?! > > > > Thanks, > > > > Alex > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > > > > -- > Alex Bovey > Web Developer | Alex Bovey Consultancy Ltd > Registered in England & Wales no. 6471391 | VAT no. 934 8959 65 > a...@bovey.co.uk | t 0844 567 8995 | m 07828 649386 | f 0870 288 9533 > PHP | MySQL | AJAX | XHTML | CSS | Javascript | XML | W3C Accessibility > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
