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. > 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 [1] http://www.howtogeek.com/72130/learn-how-to-securely-delete-files-in-windows/
