Re: Difference between drop and truncate

Detailed explanation, thanks > 在 2017年12月21日，上午11:49，Jeff Jirsa 写道： > > Assume you’re running 3.0 or 3.x - there’s a patch that’ll be in the next > releases that speed up truncate significantly - there’s some slowish code in > adding the sstables to the transaction log

Re: Difference between drop and truncate

Assume you’re running 3.0 or 3.x - there’s a patch that’ll be in the next releases that speed up truncate significantly - there’s some slowish code in adding the sstables to the transaction log before deleting them, but it’ll be much faster. Truncate marks all the data as removed, and then

Difference between drop and truncate

Hi,guys We have a very big table. when I excute "truncate table" it takes such a long time at last show "request timeout ". well, if I execute drop table which complete very quickly. I cannot see the big difference since they both delete the data. Anyone can explain it to me ?