Re: [sqlite] Bulk insert performance

2011-05-29 Thread Joe D
On 2011-05-29 06:14, Kees Nuyt wrote: > On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh" > 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

Re: [sqlite] Bulk insert performance

2011-05-29 Thread Kees Nuyt
On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh" 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. -- ( Kees Nuyt ) c[_]

[sqlite] Bulk insert performance

2011-05-29 Thread Greg Keogh
Hello team, this isn't really a bug report, it's just a heads-up about a trap for new players. I've just started evaluating the SQLite 1.0.66.0 ADO.NET provider, and I'm most impressed by the whole experience. For your possible interest I have pasted below a copy of a post I just made into the