使用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
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我