[TYPO3-mvc] Extbase performance optimization

[Alex Bailey]

Thanks for the answers,

Yes I can provide some information:

I've uploaded a pic with my basic model relations for this situation:

http://www.imagebanana.com/view/3c3xnzsn/Screenshot20100623at12.31.33PM.png


Subproject 1 : 1 Mainproject
Subproject 1 : n Jobs
Mainproject 1 : 1 Customer
Customer 1 : 1 CustomerPerson


When I print_r my list of results i get the following result for 
mainproject field:

  [mainproject:protected] => Tx_Extbase_Persistence_LazyLoadingProxy Object
                 (
 
[parentObject:Tx_Extbase_Persistence_LazyLoadingProxy:private] => 
Tx_SmediaTimetracker_Domain_Model_Subproject Object
  *RECURSION*
 
[propertyName:Tx_Extbase_Persistence_LazyLoadingProxy:private] => 
mainproject
 
[fieldValue:Tx_Extbase_Persistence_LazyLoadingProxy:private] => 20
                 )

I read *RECURSION* does that mean some mistake? I didn't use lazy 
loading alot yet so I'm glad if you could help me progress any further.

Greetings

Alex

On 6/23/10 11:45 AM, Jochen Rau wrote:
> Hi Alex.
>
> On 2010-06-23, Alex Bailey<vile at planet-generals.de>  wrote:
>> I've been working on another extbase extension for quite a while and I'm
>> glad that im nearly done. One thing bothers me though the performance is
>> quite shocking. My querys take forever to process. For example I'm
>> fetching a list with projects ( findAll()), every project has some
>> related objects which I don't need in this view so I marked them @lazy
>> in the model. Still my query with about 50 entrys exceeds 2 mb in size.
>> Is there some problem with the @lazy annotation? I'm using the latest
>> extbase checkout from the forge, or is there another way to limit the
>> query output (Define which fields are fetched in the repository
>> method?). I don't want to write raw sql querys but If I can't get this
>> fixed I'd might have to :(.
>
> There is definitely room for performance improvement in the way extbase queries for related objects. It depends upon you scenario how you can optimize your queries. Could you please provide some more information about your domain model?
>
> Regards
> Jochen