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

[Thomas "Thasmo" Deinhamer]

I've added the @lazy declaration wherever possible,
but I'm sure that there's something wrong - the shop
plugin (but with another version number) is also beeing
used in other projects and there it works well.

Only in this project, where the shop plugin had some huge
additions, it is behaving like this; crazy rendering time.

Either lazy loading is not working for some reason or something
else is really wrong. Maybe I just have a typo somewhere or
I'm missing a type definition etc. - but I just couldn't find
the source of the problem until now. So I was hoping to
get some better insight when looking at the queries.

And on trying that, I figured out, that there must be
a lot of queries performed, wheter it is Extbase or not;
but I suppose it to be Extbase, cause the other plugins
and all other pages load fast and as they should - in time.

Thank you a lot for sharing your thoughts,
Thomas

Am 12.05.2010 16:01, schrieb S.Korth:
> Thomas "Thasmo" Deinhamer schrieb:
>> Hello!
>>
>> I'm facing a strange problem on one of our projects,
>> running a small shop extension based on extbase/fluid.
>>
>> Using the latest version of TYPO3 (4.3.3) and Extbase
>> (1.2.0 Beta 1) pages need 10 or more seconds to load
>> if the page is not in the cache.
>>
>> Via PHPMyAdmin "Status" I found out, that the query
>> count explodes shortly before the page is beeing displayed.
>>
>> In other words, the page takes 10 or more seconds to
>> load, and after some seconds, right before the browser
>> gets the HTML from the server, there are 10.000 - 15.000
>> queries sent to the server in 1 or 2 seconds.
>>
>> I'm not sure if this is related to the desired TYPO3 website,
>> but it really seems that it's caused by it. And all other
>> pages on that website, just showing normal content without
>> any extensions/plugins beeing loaded, run well and fast.
>>
>> Only the pages running this specific Extbase powered
>> shop plugin are really, really slow if generated initialy.
>>
>> Is there a chance to log the SQL queries somehow
>> into a textfile or something? I tried to enable all
>> possible logging functions in the install tool etc.
>> but I didn't come to a solution.
>>
>> Thanks so much for your help, I'm really struggling with this!
>>
>> Thanks a lot,
>> Thomas
>
>
> Just another idea,
>
> maybe "Lazy Loading" can help, or do you already use it? For example for
> Object Storages, especially for big aggretations.
>
> Sascha