[TYPO3-mvc] extbase query

Federico Bernardin typo3list at bernardin.it
Tue Feb 5 18:25:00 CET 2013


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



More information about the TYPO3-project-typo3v4mvc mailing list