On 9/10/19, mailing lists <mailingli...@skywind.eu> wrote: > So, the best solution I found so far is to disable indexing while insertion > and to index the table afterwards
I think that is the best solution. Be sure to also do all of your inserts (and the CREATE INDEX statements) inside of a transaction. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users