Hinrich Aue wrote:
> I believe I have used many ways to speed up the UPDATE of many rows,
> But nothing helped so far.
>
> We open one connection, one transaction, and then we update many rows on the
> database.
>
> var command = new SQLiteCommand(Queries.SQLUpdateDocument, connection);
> 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#answer-17406727>
> This communication is only for the use of the intended recipient. [...]
This e-mail contains public information intended for any subscriber of
this mailing list and for anybody else who bothers to read it; it will
be copied, disclosed and distributed to the public. If you think you
are not the intended recipient, please commit suicide immediately.
These terms apply also to any e-mails quoted in, referenced from, or
answering this e-mail, and supersede any confidentiality notices in
those e-mails. Additionally, confidentiality notices in those e-mails
will incur legal processing fees of €42 per line; you have agreed to
this by reading this confidentiality notice.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
