[TYPO3-mvc] extbase query

Federico Bernardin typo3list at bernardin.it
Tue Feb 5 22:48:34 CET 2013


Hi Stephen,
you're right, but in my case I need to show directly the B properties when A objects list will be shown.
However the problem remains, for many records query without lazy loading the performance decreases.

regards
Federico

Il giorno 05/feb/2013, alle ore 18:52, "Stephen Bungert" <stephenbungert at yahoo.de> ha scritto:

> You can mark the properties as @lazy so that they only get collected when 
> you use them.
> 
> Stephen.
> 
> 
> "Federico Bernardin" <typo3list at bernardin.it> schrieb im Newsbeitrag 
> news:mailman.2496.1360085105.609.typo3-project-typo3v4mvc at lists.typo3.org...
> Hi list,
> I've 3 object A,B,C
> A contains reference 1:n to B and 1:n to C
> I was debugging extbase when execute a findAll method and I have discovered 
> that it executes 1 query to table A, for each line of table A executes a 
> query on table B and on table C.
> At the end of a single findAll I have A*B + A*C queries. Is it right? It is 
> a performance degradation. Is there a solution? Why doesn't it execute a 
> join?
> 
> Thanks.
> Federico
> 
> 
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc



More information about the TYPO3-project-typo3v4mvc mailing list