[TYPO3-mvc] Strange performance problem - a lot of database queries

[Thomas "Thasmo" Deinhamer]

Hello Lienhart,

thanks for sharing this!

Actually I don't use any value objects, as I haven't dug into this yet. 
I will care for the strict and clean seperation of value objects and
entities at a later point - which is related to your answer, neither
clever, because it doesn't work yet, or it points out that I'm lazy. ;o)

I'm curious about your patch, especially about fixing this weird bug;
maybe we can get Jochen into the boat for this - also related to the
offer of Felix Oertel to provide some cool debugging tools, which I
can use to find out which thousands of queries are fired at the server.

Is there a chance you can postyour enhanced patch of Xaver Koch
to the mailing list or another place like the forge etc.? Then we
all can have a look at it and figure out things better.

Thanks a lot,
Thomas

Am 12.05.2010 17:07, schrieb Lienhart Woitok:
> Hi Thomas,
>
> this is indeed a problem, I face quite similar problems. I applied a patch Xaver Koch posted on forge which helped.
>
> But if you use value objects I have bad news for you: value objects are severely broken in several ways. One thing is that value objects are always considered dirty by Extbase so each value object and objects containing value objects are dirty and thus updated in the database. I have a working version without this problem but it is most probably not a final solution. It is based on the before mentioned patch by Xaver Koch but extends it for use with value objects/cloned objects. Another point on value objects: since Jochen Rau introduced translation handling, value objects are persisted without content (since the argument $rows for insertObject() in Persistence_Backend was removed but is used to pass the content of a value object into this function).
>
> I measured performance using TYPO3 time tracking functionality resulting in something like 800 milliseconds for controller and 1300 milliseconds for persistence before solving this, about 800 ms for controller, 80 ms for persistence afterwards. There were about 80 objects handled by persistence, the template displayed near to nothing (missing lazy loading, but that is not the point here).
>
> I attached a patch that helped me here but I should mention that I'm neither sure whether this is a solution or just fighting symptoms (I suspect latter) nor that this is stable. Therefore I did not put it on forge yet. If you don't use value objects this patch should still help you.
>
> If you apply this patch I'd be pleased to hear feedback from you.
>
> Good luck.
>
> Regards,
>
> Lienhart Woitok
> Web-Entwickler
>
> Telefon: +49 (911) 539909 - 0
> E-Mail: Lienhart.Woitok at netlogix.de
>
>
> --
> netlogix GmbH&  Co. KG
> Systemhaus | Trainingscenter | Medienagentur
> Andernacher Straße 53 | 90411 Nürnberg
> Telefon: +49 (911) 539909 - 0 | Fax: +49 (911) 539909 - 99
> E-Mail: mailto:info at netlogix.de | Internet: http://www.netlogix.de/
>
> netlogix GmbH&  Co. KG ist eingetragen am Amtsgericht Nürnberg (HRA 13338)
> Persönlich haftende Gesellschafterin: netlogix Verwaltungs GmbH (HRB 20634)
> Umsatzsteuer-Identifikationsnummer: DE 233472254
> Geschäftsführer: Stefan Buchta, Matthias Schmidt
>
>
>