[TYPO3-mvc] Extbase performance optimization

[Philipp Wrann]

You need to know that is the bottleneck.

Check your slow_query_logs, maybe install xdebug and make a profile.

I guess you should add some @lazy annotations to your domain objects

You can also set the SQL log config (in typo3) to 2, so *all* queries are shown, that will probably help you track down your problem.

Serverside slowness is in 99% of all cases I/O, so everything related to database and file handling.

Also debug your queries using the explain statement, see if some queries using your extensions tables dont use an index.

Adding some index and setting the properties @lazy will probably speed up your uncached call a lot.

show us your ext_tables script, and the queries, that are performed on those tables.

At last you can also tweak mysql itself, but i would go for the other options first.