database - 删除表 vs 删除其内容 sqlite

Question

在我的应用程序中，我必须删除表格的全部内容并多次重新填充它

在那种情况下，我有两个解决方案:

1- 放下，重新创建并填充表格

"DROP TABLE IF EXISTS TABLE_NAME"

2- 移除所有内容并重新填充

"DELETE FROM TABLE_NAME"

现在哪个解决方案更有效？

Answer 1

来自 http://www.sqlite.org/lang_delete.html :

The Truncate Optimization

When the WHERE is omitted from a DELETE statement and the table being deleted has no triggers, SQLite uses an optimization to erase the entire table content without having to visit each row of the table individually. This "truncate" optimization makes the delete run much faster.