2016-04-20 10:44 GMT+02:00 Dominique Devienne <ddevienne at gmail.com>:
> On Wed, Apr 20, 2016 at 10:36 AM, Cecil Westerhof <cldwesterhof at gmail.com> > wrote: > > > I am baffled. Still DELETE before DROP is a lot more efficient. And it > > looks that it is not bothered when other programs are running (most of > > the time). I would think that a DROP should take the least time: > > > > I agree. That's weird. Needs investigating indeed. > ?Do the developers reed this list, or should I post a bug report? ? > > Also: I understand that SECURE_DELETE=1 takes more time, but the > > difference seems excessive. What could be happening here? > > > > Secure delete is basically writing to the disk several times, with random > data. > From [1], it appears to be between 1x and 35x times. Don't know how SQLite > does secure-delete. --DD > ?I will look into it later. Thanks. -- Cecil Westerhof
