How to improve the speed of sqlite

[jeffrey8227]

   j=1000
   con.BeginTransaction 
   For i=1 To 1000
         Cmd.CommandText ="update TBNR set XH='" & (j+1) & "' Where ( XH ='" & j & "')"
         j=j-1
         cmd.ExecuteNonQuery
   Next i
   con.EndTransaction

In my HTC touch pro to complete the above code to take about 10 seconds

How to improve the speed?

 

[jeffrey8227]

Who can help me?

 

[Erel]

SQL is powerful.
Try something like:

    cmd.CommandText = "update TBNR set XH=XH+1 where XH <= 1000"
    cmd.ExecuteNonQuery

 

[jeffrey8227]

Thanks Erel
I'll try it