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

前端技术 2023/09/01 C#

使用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

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见,何事秋风悲画扇。