[TYPO3-mvc] delete reflection takes ages - performance of whole site goes down

[Thomas "Thasmo" Deinhamer]

I may be wrong, but in case of a complete delete
of all records in a table, there is already a patch for
using the latest addition to DBAL 'truncate' which is
a lot faster than deleting them manually.

Have a look here:
http://forge.typo3.org/issues/show/7226

But I'm not sure this request is related to your problem.

Regards,
Thomas


Am 16.04.2010 10:03, schrieb ralph:
> i try to debug my first bigger extbase extension. well.. i was wondering
> why site generation takes long i am new to xdebug but i tracked down
> that i have several long lasting mysql transaction caused by reflection.
> stack trace:
> t3lib_DB->exec_DELETEquery >> t3lib_cache_backend_DbBackend->remove <<
> t3lib_cache_backend_DbBackend->set
> <<tx_extbase_reflection_service->savetoCache <<
> tx_extabse_reflection_service->shutdown <<tx_etbase_dispatcher took
> 3.859ms and some more of them. anyone can give me a hint for performance
> improvements?