title: Doctrine2...Best hydration mode?
body: <p>I am designing a room booking system which has nine entities, which all relate to each other. In this specific instance I am retrieving 10-30 rows from the entity <code>entry</code> which has 25 properties. Each entry has one <code>room</code> which has 10 properties. I need all of the entry information as well as <code>entry-&gt;room-&gt;id</code> and <code>entry-&gt;room-&gt;name</code>. But it seems like doctrine is loading the entire <code>room</code> when I use <code>Query::HYDRATE_ARRAY</code>. It seems to be lazy-loading in <code>Query::HYDRATE_OBJECT</code> more easily.</p>
  
  <p>So, I am wondering if using the <code>Query::HYDRATE_OBJECT</code> mode is faster or "better" than <code>Query::HYDRATE_ARRAY</code> / <code>Query::HYDRATE_SCALAR</code>/ <code>Query::HYDRATE_SINGLE_SCALAR</code>. Since I am reusing some older code I'd like to use <code>HYDRATE_ARRAY</code> but only if it won't slow the application down.</p>