[sqlite] Is it possible that dropping a big table takes very long

[Simon Slavin]

On 19 Apr 2016, at 1:49pm, Cecil Westerhof <cldwesterhof at gmail.com> wrote:

> ?Is it not strange that first DELETE and then DROP is so more efficient as
> just a DROP?

Yes.

Can you please try the same comparison in the SQLite shell tool ?  You can use

.timer ON
DELETE FROM myTable;
DROP TABLE myTable;
.timer OFF

Simon.