[TYPO3-mvc] Extbase performance optimization

[Franz Koch]

On 23.06.2010 13:12, Alex Bailey wrote:
> I want to fetch
> Subproject.name
> Subproject.mainproject.name
> Subproject.mainproject.customer.name
>
> So thats a pretty complex query right there, I also think thats the
> problem why everything runs so slow for me.
> Is there any way to speed this up?

not in OO I fear. All you can do is to make everything else (like the 
customerPersons and jobs) lazy loaded, but you need to fetch the whole 
mainProject and customer in these cases.
But the good thing is - if customers repeat, they only get fetched once 
from DB.

-- 
kind regards,
Franz Koch