[FLOW3-general] Problem with Object-Associations after having updated to FLOW3 1.1rc2

[Regine Rosewich]

Von: Regine Rosewich <reggaeny at me.com>
Betreff: Re: [FLOW3-general] Problem with Object-Associations after having updated to FLOW3 1.1rc2
Datum: 29. August 2012 11:52:38 MESZ
An: General discussion about FLOW3 <flow3-general at lists.typo3.org>


Hi, Thomas,

I dug myself a bit into the documentation of doctrine-2 and did a lot of tests. I finally found out that it had to do with the ManyToMany Associations I used(don't ask me what exactly caused the problems, but the Doctrine-Hydration produced ten-thousands of Queries when inserting one object). So I decided to give up any ManyToMany Association by splitting them into two OneToMany Associations with a dedicated Join-Class between. Additionally I use 'fetch="EXTRA_LAZY"' whenever it makes sense.

My application now is flashingly fast again (whooow!) and the use of the join-classes makes the architecture of the application much more handy as I feel.

Regine

Am 29.08.2012 um 11:03 schrieb Thomas Plessis:

> Hi Regine,
> 
> In my case, manipulation of large datasets is quite slow with FLOW3 1.1 and i've less amount of objects than you. Do you have any coding tips or objects relations guidelines to improve performances? And are you using lazy loading?
> 
> Globally, is there any things to know to improve performance with FLOW3?
> 
> regards,
> 
> Thomas Plessis
> Développeur multimédia
> --
> TOTEMnumerique
> 9, Place St Étienne
> 31000 Toulouse
> T. 05 61 14 64 54
> F. 05 61 14 64 55
> 
> Le 20 août 2012 à 12:06, Regine Rosewich a écrit :
> 
>> Hi everyone,
>> 
>> 
>> 
>> I updated my considerably large application to FLOW3 1.1rc2 this weekend
>> (from FLOW3 1.0). The application has some core objects/classes which are
>> associated to up to 6 other objects/classes with OneToMany or ManyToMany
>> Associations. The amount of data is quite large (10.000 to more than
>> 1.000.000 datasets) in the main object/class and the associated
>> objects/classes.
>> 
>> 
>> 
>> With FLOW3 1.0 updating and adding items to the main object/class worked
>> fine and satisfyingly performant. With FLOW 1.1rc adding one item produces
>> 20!! MB of Query-Log (with tons of queries to the associated tables) and
>> takes 5!! Minutes compared to some seconds with FLOW3 1.0. 
>> 
>> 
>> 
>> I intensely studied the documentation but did not find a hint what might be
>> wrong with my application.
>> 
>> 
>> 
>> Regine
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> FLOW3-general mailing list
>> FLOW3-general at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general
> 
> _______________________________________________
> FLOW3-general mailing list
> FLOW3-general at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general