On 1 Oct 2016, at 10:18pm, Domingo Alvarez Duarte <mingo...@gmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users