On 1 Oct 2016, at 10:18pm, Domingo Alvarez Duarte <[email protected]> wrote:
> About the vacuum I also understand the need to rewrite the whole database but
> I'm not sure if it's really necessary to do almost 5 times the database size
> in both reads and writes (also an equivalent amount of I/O happened during
> insertions).
Can you try it without
db.exec_dml("PRAGMA wal_checkpoint(FULL);");
and see if that improves time ?
That's the only thing I can see. You're using a nested INSERT OR IGNORE
command I'm not familiar with.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
