使用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);      }新聞熱點
疑難解答