On 14 Aug 2017, at 7:52am, Clemens Ladisch <clem...@ladisch.de> wrote:
> Wrap everything into a single transaction. > <http://www.sqlite.org/faq.html#q19> and CREATE the INDEXes after doing the INSERTs: BEGIN CREATE TABLE … INSERT … CREATE INDEX … COMMIT BEGIN SELECT … COMMIT Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
