2016-04-19 15:12 GMT+02:00 Simon Slavin <slavins at bigfraud.org>: > > 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 >
?Was done in the shell tool. But with timing done by Bash. I have to go, but I will try this later. -- Cecil Westerhof
