[TYPO3-mvc] Extbase Performance

[Stefan Frömken]

Am 30.07.2012 17:08, schrieb Thomas "Thasmo" Deinhamer:
> Alright, after having a closer look
> the performance issue only occurs on
> larger tables (> 2.000.000 rows).
>
> Not sure if it's caused by Extbase
> or if it's just my small experience
> defining correct keys for the table.
>
> Does anyone else have performance
> problems with larger tables and Extbase?
>
> Thanks a lot,
> Thomas
>
> Thomas "Thasmo" Deinhamer schrieb:

We have a table with over 1.000.000 records. We need some days for 
profiling the queries to configure the best indizes. We also have 
configured MySQL to speed up sorting procedures.
The biggest problem is Fluid with its Partials and a table view. We had 
a partial for each TD-Tag and a table showing a little bit more than 
1000 rows with 12 cols. Following happens:

12 * 1000 = 12.000 callings to our td partial

Each call to a partial needs 6 Millisecond:

12.000 * 6 = 72.000ms = 72 seconds

We don't have any problems with creating 1000s of models (it's less than 
a millisecond). The problem is the view.
Now we have created a bigger TR partial and the view is ready within 3-5 
seconds (TYPO3 4.5).

Stefan