Doctrine : Lazy loading properties

Question

It looks like when I forget to put leftJoin in my queries, Doctrine will lazy-load relations after I pick them. Ie if I do something like:

$property = PropertyTable::getInstance()->createQuery('o')
  ->leftJoin('o.Features f')
  ->execute() ;

I will still be able to access $property->Attraction , even if I didn't load them in this query. So I guess Doctrine does it internally by calling another 'SELECT'. Is there a way to prevent this auto-loading by throwing some exception? This would help me create better and faster queries.

Answer 1

Have you looked at the actual sql it produces?

Try ->getSql(). It is likely it is doing another query when you attempt to access a related field.

If you want to avoid that, don't access related fields!