On 17 May 2017, at 5:05pm, Simon Slavin <slav...@bigfraud.org> wrote:
> Fastest way to do bulk inserts would be to delete all the indexes which don’t > play any part in identifying duplicates, then do the inserting, then remake > the indexes. I forgot: once you’ve remade the indexes run ANALYZE. That’s the only time you need to do it. At that time you have typical data in the tables and SQLite will be able to gather all the data it needs to figure out good strategies. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users