sqlite多行插入_SQLite大批量插入性能优化

string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString;using (SQLiteConnection con = newSQLiteConnection(strconn))

{

con.Open();using (SQLiteTransaction trans =con.BeginTransaction())

{using (SQLiteCommand cmd = newSQLiteCommand(con))

{

cmd.Transaction=trans;try{using (FileStream fs = File.OpenRead("*.txt"))

{using (StreamReader sr = newStreamReader(fs))

{stringsline;string[]arr;stringstr;

rCount= 0;while(!sr.EndOfStream)

{

sline=sr.ReadLine();

arr= sline.Split(',');

str= "INSERT INTO XXXTABLE (A,B,C,D,E,F,G,H,I,J) VALUES(@A,@B,@C,@D,@E,@F,@G,@H,@I,@J)";

cmd.CommandText=str;

cmd.Parameters.AddWithValue("@A", arr[0]);

cmd.Parameters.AddWithValue("@B", arr[1]);

cmd.Parameters.AddWithValue("@C", arr[2]);

cmd.Parameters.AddWithValue("@D", arr[3]);

cmd.Parameters.AddWithValue("@E", arr[4]);

cmd.Parameters.AddWithValue("@F", arr[5]);

cmd.Parameters.AddWithValue("@G", arr[6]);

cmd.Parameters.AddWithValue("@H", arr[7]);

cmd.Parameters.AddWithValue("@I", arr[8]);

cmd.Parameters.AddWithValue("@J", arr[9]);

cmd.ExecuteNonQuery();

rCount= rCount + 1;

}

}

}

trans.Commit();//5,清空txt

System.IO.File.WriteAllText(path + "*.txt", "", System.Text.Encoding.Default);

}catch(Exception ex)

{

rCount= 0;

trans.Rollback();

}

}

}

}