[TYPO3-mvc] findAll() with child objects performance

[Lorenz Ulrich]

Thanks guys!

Lazy loading it is. I will try with lazy loading only for the moment and 
keep an eye on performance.

Depending on the result I will try enetcache extension.

Best regards,

Lorenz

Am 01.02.2012 08:01, schrieb Daniel Schöne:
> Hi Lorenz,
>
> on top of lazy loading you might want to have a look @ the enetcache extension, with makes the caching framework available to extensions.
>
> cheers,
> daniel
>
> On Feb 1, 2012, at 2:31 AM, Adrien Crivelli wrote:
>
>> Uhm, I meant actually 1 + 200 * 20 queries. But that's still a lot...
>>
>> On 1 February 2012 10:21, Adrien Crivelli<adrien.crivelli at gmail.com>  wrote:
>>
>>> Hi,
>>>
>>> In your case, you'll have at least 200 + 200 * 20 SQL queries executed.
>>> This is a lot. Lazy loading would probably be your best bet to reduce
>>> queries count if you don't always need those child objects. Cannot find
>>> official documentation about it, but here is an example:
>>>
>>> http://forge.typo3.org/projects/extension-newsletter/repository/diff?rev=55991&type=sbs