Importing large amounts of data issues many truncate's
While importing large amounts of data (e.g. while installing a distribution), \TYPO3\CMS\Core\DataHandling\DataHandler::clear_cache() is called for each record.
clear_cache() in turn tries to clean each related page frontend cache and finally (because of the default setting) deletes the cache group pages.
This results in some 10000 truncate calls being issued to the database.