[TYPO3-mvc] findAll() with child objects performance
lorenz-typo3 at visol.ch
Fri Feb 3 16:47:21 CET 2012
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.
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.
> 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:
>>> 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:
More information about the TYPO3-project-typo3v4mvc