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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
