C#快速批量给SQLite插入数据 C#/.Net 中快速批量给SQLite数据库插入测试数据
人气:0想了解C#/.Net 中快速批量给SQLite数据库插入测试数据的相关内容吗,在本文为您仔细讲解C#快速批量给SQLite插入数据的相关知识和一些Code实例,欢迎阅读和指正,我们先划重点: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); }
加载全部内容