[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

[Clemens Ladisch]

Chris Prakoso wrote:
>         public bool UpdateData(string tableName, Dictionary<string,object> 
> fields, List<string> whereKeys)
>         {
>             ...
>                     using (SQLiteTransaction transaction = 
> conn.BeginTransaction())
>                     {
>                         ...
>                         rowsUpdated = cmd.ExecuteNonQuery();
>                         transaction.Commit();

Using one transaction for each statement is slow.
(Re-opening the database doesn't help either.)

You should use a single transaction around all update statements.


Regards,
Clemens