C# · 12月 28, 2021

C#/.Net 中快速批量给SQLite数据库插入测试数据

使用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); }