you can use

ALTER TABLE DROP COLUMNS CHECKPOINT XXX

where XXX is number of rows, this issue a commit every XXX rows