Yes. Nothing complicated, fortunately. On Tue, Feb 9, 2016 at 4:09 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote:
> So are you saying you are just reading data from your SQLite db using C# > and > just need to insert using the SQLite command? > > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris > Prakoso > Sent: Tuesday, February 9, 2016 7:56 AM > To: SQLite mailing list > Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is > slower than without. > > Steven, > > I don't use any back-end, the code I pasted here IS my back-end. I opted > for direct SQLite connection. So I don't use EF6 nor Linq. > > Chris > > On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < > steven.mcneese at freedomparkdfw.com> wrote: > > > 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-user > > >> s > > > _______________________________________________ > > > 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 > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
