[TYPO3-mvc] Extbase performance issues

[Alexander Dick]

Am 04.07.2012 12:05, schrieb 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.
>

Hi,

actually the whole search and filter thing runs really quick.
The only problem is the record listing, when there is a large amount of 
records.

>
>> 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.
>

I already used the paginate widget a couple of times - I'm building it 
in right now to reduce my monster table ;-)

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

That would be really nice too but I think for now even a normal 
pagination would be a huge improvement, regarding performance and 
waiting time in front of the screen.

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

Thanks!