c# - Insert takes too long, code optimization needed -

I have some code that I call table1 to the second value table2

(Windows Mobile Smartphone)

What do I do? Can i do

  CMD Type in the CommonText = "Select 2 to + + Select + + Table Name". "+ TableName +" "cmd.ExecuteNonQuery ();  

Edit

The issue has not been resolved I am also after the answer.

1] You have your connection string

  string connection string = @ "data source = e: \ myDB.db3; New = true; Version = 3; Praga cache_sage = 20000; Prava Page_sys = 32768; Praga synchronous = off ";  

Check for details for which its limits are

The above cache size will eventually increase (cache_use and Page_isize), but you When closing the system, some data may be lost (synchronous = closed).

2] You can wrap your insert details within such transactions

  DbTransaction = dbConnection.BeginTransaction (); DbCommand.Transaction = DBTransaction; // Your Personal Insertion Statement here dbTransacti On.Commit ();  

3] There is another move that is well explained. See this

Hope that helps
Cheers !