System. Data. SQLite: Batch add data

Today, we encountered a situation where we inserted more than 1400 pieces of data into the SQLite database. It takes one or two minutes to complete the result each time.
After searching, the solution is found here, and the required time is less than 2 seconds!

Internal static void fastinsertmany (dbconnection CNN)
{
Using (dbtransaction dbtrans = CNN. begintransaction ())
{
Using (dbcommand cmd = CNN. createcommand ())
{
Cmd. commandtext = "insert into testcase (myvalue) values (?) ";
Dbparameter field1 = cmd. createparameter ();
Cmd. Parameters. Add (field1 );
For (INT n = 0; n <100000; n ++)
{
Field1.value = N + 100000;
Cmd. executenonquery ();
}
}
Dbtrans. Commit ();
}
}