Chris,
What are you using in c# for SQLite back end? Ado.net? Linq. Let me know and
I can help you with bulk inserts.
Sent from my iPhone
> On Feb 9, 2016, at 6:13 AM, Chris Prakoso <chris at prakoso.net> wrote:
>
> 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
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
