I believe it's also helpful to avoid creating indexes (and enforcing foreign keys) until after the import.
On Mon, Apr 1, 2019 at 7:15 AM Gert Van Assche <ger...@gmail.com> wrote: > Hi all, > > I need to create an SQLite db from a large TSV file. (30 GB) > Are there any setting I can give to the db so I can speed up the import? > > thank you > > Gert > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
