使用transaction:
var stopwatch = new Stopwatch(); using (var cmd = new SQLiteCommand(db_con)) using (var transaction = db_con.BeginTransaction()) { stopwatch.Reset(); stopwatch.Start(); foreach (var item in sorted) { sql = string.Format(\"insert into db (st1, st2) values (\'{0}\', {1})\", item.Key.Replace(\"\'\", \"\'\'\"), item.Value); cmd.CommandText = sql; cmd.ExecuteNonQuery(); ++readCnt; if (++readCnt % 1000000 == 0) { Console.Write(\"\\rDumped {0} lines...\", readCnt); } } Console.Write(\"\\rCommitting....\"); transaction.Commit(); stopwatch.Stop(); Console.Write(\"\\rDumped {0} lines using {1} seconds...\", readCnt, stopwatch.Elapsed.TotalSeconds); }
本文地址:https://www.stayed.cn/item/1625
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我