（C#版本）提升SQlite数据库效率——开启事务，极速插入数据，3秒100万，32秒1000万条数据

 1 using System;
 2 using System.IO;
 3 using System.Data.SQLite;
 4 using System.Diagnostics;
 5 using System.Data.Common;
 6 
 7 namespace SqliteTran
 8 {
 9     class Program
10     {
11         static void Main(string[] args)
12         {
13             DbProviderFactory Dbfactory = SQLiteFactory.Instance;
14             using (DbConnection dbCOnn= Dbfactory.CreateConnection())
15             {
16                 //连接数据库
17                 File.Delete("NBA.db4");
18                 dbConn.COnnectionString= "data source =  NBA.db4";
19                 dbConn.Open();
20                 //创建数据表
21                 string sql = "create table Garnett ([age] INTEGER PRIMARY KEY, [s] TEXT COLLATE NOCASE)";
22                 DbCommand cmd = dbConn.CreateCommand();
23                 cmd.COnnection= dbConn;
24                 cmd.CommandText = sql;
25                 cmd.ExecuteNonQuery();
26 
27                 // 添加参数
28                 cmd.Parameters.Add(cmd.CreateParameter());
29                 // 开始计时
30                 Stopwatch watch = new Stopwatch();
31                 watch.Start();
32 
33                 DbTransaction trans = dbConn.BeginTransaction();
34                 // 连续插入记录
35                 for (int i = 0; i <1000000; i++)
36                 {
37                     cmd.CommandText = "insert into Garnett ([s]) values (?)";
38                     cmd.Parameters[0].Value = i.ToString();
39                     cmd.ExecuteNonQuery();
40                 }
41  trans.Commit(); 
42                 dbConn.Close();
43                 // 停止计时
44                 watch.Stop();
45                 Console.WriteLine(watch.Elapsed);
46                 Console.ReadLine();
47             }
48         }
49     }
50 }