Has_One Relation Is Always Eager-Loaded?

Yii 1.1 General Discussion
1

Hi,

I found out if a model has a relation using HAS_ONE, then it’s always eager-loaded even when we only access the model itself.

eg.


class User extends CActiveRecord {


  public function relations()

  {

    $relations = array();

    $relations['profile'] = array(self::HAS_ONE, 'Profile', 'user_id');

    return $relations;  

  }


}

If we call that model in the controller:


$user = User::model()->findByPk(1);

In the trace log, I saw the query joins User with Profile table. Why is it not lazy loaded? The application will access User many times and most of the time we don’t need the Profile data. I thought the Profile will only be retrieved when we explicitly write $user->profile, but it is not. Wouldn’t it better if it’s lazy loaded, or do I miss something here?

2

Hi explorer,

It sounds very strange. The related models should always be loaded lazily when you haven’t used ‘with’. The chances are, I believe, you have specified ‘with’ somewhere. Double check your source code and the trace log.

3

Hi softark,

Thank you for your clarification. I’ll check my code again, as I’m using some extensions there may be something that I didn’t see.

4

check also if you have assign ‘behaviour’ in your model

did you have another model with similar code? has trhe same issue?

if it is possible possible entire model class here

5

Ok, I found where the issue came from. I’m updating this thread so maybe it’s useful for someone.

I’m using Yii-user module and there is this code:




class UserModule extends CWebModule

{

...

public $defaultScope = array(

    'with'=>array('profile'),

  );

and $defaultScope is used in User model:




  public function defaultScope()

  {

    return CMap::mergeArray(Yii::app()->getModule('user')->defaultScope,array(

    ...

    ));

  }

Problem solved. Thanks for all helps.