Hello Gert !
I normally do this (be aware that if there is a power outage the
database is screwed):
===
PRAGMA synchronous = OFF;
begin;
--processing here
commit;
PRAGMA synchronous = ON;
===
Cheers !
On 1/4/19 13:14, Gert Van Assche 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
