On 2011-05-29 06:14, Kees Nuyt wrote: > On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh"<g...@mira.net> > wrote: > >> I'm utterly gobsmacked by the poor performance of the >> inserts without a transaction around them. > > It's a FAQ, > http://www.sqlite.org/faq.html#q19 > explains the reasons quite clearly.
Also see the section named "Tips on Optimizing Your Queries" in the SQLite.Net help files. The advice there applies to any .NET data provider, not just SQLite.Net. Joe D _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
