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

[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