[TYPO3-dev] How standard compliant is "truncate"?

[Steffen Kamper]

Hi,

Peter Kuehn [wmdb] schrieb:
> Hi yall,
> 
> some questions to those, who know more about databases than i do:
> 
> How standard compliant is "truncate table"?
> On which DBMS will it work or not work?
> Is ADODB able to rewrite it where it does not work?
> 
> Background:
> I plan to submit a patch request for t3lib_tcemain->clear_cacheCmd() 
> where $cacheCmd=='all', if truncate table will not break DBAL.
> The currently used "DELETE FROM cache_*" calls end up as an entry in 
> slow query logs on larger installs.
> 
> thnx in advance
> pekue

as i know it will lead to problems on oracle etc.

For that reasons i made an extension "truncate_tables" which is used for 
some clients having MySQL only.

vg Steffen