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

Reply via email to