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

[Thomas "Thasmo" Deinhamer]

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