- Use CakePHP's Containable Behavior to only retrieve the associated data you want
Example of code:
//wherever you set this variable $paginate = array( 'recursive' => -1, 'limit' => 50, 'order' => array('Artist.id' => 'desc'), 'contain' => array( 'ArtistSurname', 'ArtistForName' ) );
Remember to look through the documentation for Containable - it explains how you set your Model(s) to
$actsAs Containable, set recursive to -1...etc etc.
I suggest actually setting
public $recursive=-1' and
public $actsAs =array('Containable'); both in your AppModel - that way ALL models are set up and ready to go with Containable whenever you want. Also, anything higher than -1 for recursive is bad IMHO - Containable is so much better in every respect.