[TYPO3-mvc] Extbase - bad performance when not default language
Jan Kornblum
jan.kornblum at gmx.de
Tue Sep 15 18:39:19 CEST 2015
Sorry, the relations are: B < 1:n < A > n:1 > C ;) But for testing,
i've just removed all relations from tca and the models to find out the
reason for performance issue:
Now i fetch all A-records (~2.000) using $repo->findAll(), and iterate
over them using a foreach inside the controller. Nothing is being
passed to fluid, no other code is called from this plugin.
Calling the page containing the plugin now takes about 3 seconds in
L=0, but nearly 9 seconds in L=1.
As soon as i remove the iteration (the plugin now simply does
$repo->findAll() and nothing more), calling the plugins page takes 2
seconds in L=0 as well as in L=1.
Is this a common behaviour in extbase?? I can't believe that 2.000
records (all tranlated once) in conjunction with a simple iteration
over them could lead to such a big performance difference!?
What am i missing?
Kind regards, Jan
P.S. The situation above is just an example to find out the reason for
this bad performance. The real application needs some more iterations
and calculations, which leads to unacceptable execution times in L=1.
More information about the TYPO3-project-typo3v4mvc
mailing list