Ok. Got it.
Now, if only I can get that multiple rows update working on my code, it
would be perfect.
Thanks a lot,
Chris
On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch <clemens at ladisch.de> wrote:
> 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
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
