jasonfrye's avatar

jasonfrye liked a comment+100 XP

1mo ago

Best way to truncate very large data table?

INSERT INTO change_logs_backup SELECT * FROM change_logs;

It would take forever. For backup I'd rename change_logs to change_logs_backup and create change_logs from scratch. Same result but almost instantly.