2016-04-19 15:27 GMT+02:00 Olivier Mascia <om at integral.be>: > > Le 19 avr. 2016 ? 14:49, Cecil Westerhof <cldwesterhof at gmail.com> a > ?crit : > > > > SECURE_DELETE > > Are you aware of the net effect of SQLITE_SECURE_DELETE? > > https://www.sqlite.org/compile.html#secure_delete > > The documentation talks about a "small performance penalty", yet on very > large tables, especially if overflowing by large the cache size, the amount > of IO for overwriting deleted data with zeroes can become substantial. Not > to say this is the sole reason for your issue, but it should have an impact > on it. > > You should run "PRAGMA secure_delete=0" before doing this bulk deletion > and see how it impacts your timings. >
?Nope, I am just starting to play with SQLite. Maybe playtime is over and reading time starts. ;-) Thanks. -- Cecil Westerhof
