Re: [sqlite] UPDATE of many rows is very slow

onnection); > foreach (DataRow documentRow in rowsToUpdate) > { > command.ExecuteNonQuery(); Already answered on StackOverflow ("command.Transaction = transaction;" was missing): <http://stackoverflow.com/questions/17406438/sqlite-update-of-many-rows-is-very-slow#answ

[sqlite] UPDATE of many rows is very slow

Hello sqlite users, I believe I have used many ways to speed up the UPDATE of many rows, But nothing helped so far. We are opening a transaction, like this: private SQLiteTransaction BeginTransaction(SQLiteConnection connection) { return