[TYPO3-mvc] Extbase performance issues

[Alexander Dick]

Hi Patrick,

Am 04.07.2012 10:53, schrieb Patrick Schriner:
> Hi Alex,
>
> - if you have objects that have lots of objects as properties switching
> those the @lazy loading model might help.
>

I have already tried that, but it leads to problems. If i remember 
correctly, I get an error when I try to access a property that has the 
lazy annotation.

> - if you are running TYPO3 4.5, switching to 4.6 or higher should
> provide an even bigger boost.
>

I'm running TYPO3 4.6.7

kind regards
Alex

> Patrick
>
> On Wed, 04 Jul 2012 10:23:31 +0200, Alexander Dick <typo3 at dick.at> wrote:
>
>> Hi Folks,
>>
>> I developed an extbase application where people can apply for
>> different jobs via the frontend, the applications are then being
>> processed in the backend by different editors.
>>
>> The data structure of such an application is rather complex, there are
>> lots of different models and relations.
>>
>> The problem is:
>>
>> 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.
>> In the beginning all went well, as there were not much applications yet.
>>
>> Now we have > 1500 applications and the list takes about 30 to 60
>> seconds to load. The cause is obvious - there's a huge amount of
>> objects that have to be loaded in order to display that table.
>>
>> Simplest solution would be a pagination but I wanted to ask you guys
>> if I could make something different to improve the performance?
>> Is there a trick speed up things when it comes to lots of objects in
>> extbase?
>>
>> Thanks a lot
>> Alex