Hey,
This code below works well but the query is really slow. It adds five
seconds more to the page request time. Am I doing something wrong or
is it just the way it is? Also, is there a way to do this with a
custom query and would it be any quicker? Thanks in advance!
$this->Category->Behaviors->attach('Containable');
$tempCategories = $this->Category->find('all', array(
'fields' => array('id','title','description','order'),
'order' => array("Parent.title" => "asc","Category.order" => "asc"),
'contain'=>array(
'Parent' => array('fields' =>
array('id','title','description')),
'Product' => array('fields' =>
array('id','title','description'),
'conditions' => array('active'=>1),
'Variation' => array('fields' =>
array('id','title','price'))
))));
--
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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
