[TYPO3-mvc] Extbase performance issues

[Bastian Waidelich]

Alexander Dick wrote:

Hi Alexander,

> In the backend module we have a list of all applications, sort- and
> filterable by different properties (which belong to different related
> models). Also there is a start and end date filter to limit the records.

IMO Extbase is not the right tool for searches/filters over large data 
sets. Have you considered using an indexer like Solr or ElasticSearch?
If you hook into the repository and create/update the index, that works 
transparently.


> Simplest solution would be a pagination but I wanted to ask you guys if
> I could make something different to improve the performance?

If you used the QOM adding pagination should be really easy:
Just add
<f:widget.paginate objects="{applications}" as="paginatedApplications">
</f:widget.paginate>

around your foreach and replace {applications} by 
{paginatedApplications} within.

You can also combine that with some "infinite scrolling" javascript to 
hide the page navigation.

That will greatly reduce the memory consumption, but if the search 
itself takes a long time you should really consider proper indexing.

Best


-- 
Bastian Waidelich
TYPO3 Core Team Member

TYPO3 .... inspiring people to share!
Get involved: typo3.org