Hi Friends,

I am back again. Now there are 10000 cases where we need to get the results from a table with specific set of fields. Like we need to get

$this->find("all", array("fields" => "User.firstname, User.lastname, User.avatar","order" => "User.last_login DESC", "limit" => $cnt));

Now if the parent table be User and it have so many associations then this find will join all the other sets of fields in other Associated tables.
To avoid this use the following
(I am writing code for model. If controller specify the model also. eg: $this->User->recursive = -1 etc)

function active_users($cnt = 9){
    	$this->recursive = -1;
    	return $this->find("all", array("fields" => "User.firstname, User.lastname, User.avatar","order" => "User.last_login DESC", "limit" => $cnt));
    }