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

[Thomas "Thasmo" Deinhamer]

Hello and thanks for you reply!

Unfortunately the project is on a shared
host, so I'm not able to access or use
the MySQL daemon directly.

Isn't there a way to hack into the source,
putting a line somewhere, which could write
the SQL statements into a file or sth?

Thank you,
Thomas

Am 12.05.2010 12:28, 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
>
>
> Hey Thomas,
>
> your can use the "query log" within mysql for example.
>
> http://dev.mysql.com/doc/refman/5.0/en/query-log.html