Hi,
We are using Sqlite3 with Golang to do bulk insert.
Need to insert close to 10 Million records to sqlite3 in around 30 mins.
Currently I am saving 100 Records under one transaction with below settings:
PRAGMA synchronous = NORMAL;
PRAGMA journal_mode = WAL;
PRAGMA auto_vacuum = FULL;
I read about SQLITE_MAX_SQL_LENGTH, Is it better to tune this value?
Also, read about sql bind feature, but not very sure how to do in Golang?
Is there any better way to do bulk insert?
Thanks,
Niti
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
