[TYPO3-mvc] filter and pagination views of own extension really slow

[Philipp Wrann]

1) don use noCache, with noCache in your Request you dont use any caches
use a separat action that is uncached, for example results. Then you can display lists (cached) or result-views (uncached)

You could also display a list and get the dynamic results via ajax only but i would not do that.

2) Maybe you have bad property tagging, like mentioned before look if you have set @lazy for all subproperties, especially for ObjectStorages

3) Check your index
get your query (enable sqldebug in install tool) and do an explain statement against your database, maybe no index can be used or your index is not optimal, in combined indexes allways put the best filter in the first place and add tha constraint in first position.

4) link generation
link generation is extremely slow in typo3, if you have the same link multiple times in your partial try to use an own viewhelper hat makes use of some firstlevel proxy cache to generate the same uris only once. this can safe 100s od ms parsingtime.